Buy Now
Sign in

How to concatenate two fields from the #__index_users table to show in the dropdown

mauropiro , October 11 at 19:13
M
mauropiro
Dear Sirs,
How do I concatenate two fields from the #__index_users table to show in the dropdown?​
​​
​I currently have in the 'fields to retrieve' field Data16.id Data16.username, and in the dropdown it appears​
​Data16.username​
​My 'users' table:​
0.png
My 'fields to retrieve' field
1.png
My returned sql
2.png
My front end dropdown
3.png
The desired front end drop down
4.png
Thank you in advance
Mauro
healyhatman
In fields to retrieve:
CONCAT(model.field , " - " , model.field2):model.alias
or
CONCAT(field , " - " , field2):alias
Pay attention to the spaces between the commas.
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman
M
mauropiro
Dear Healyhatman
It worked perfectly, you're awesome,
Thank you.
Mauro