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:

My 'fields to retrieve' field

My returned sql

My front end dropdown

The desired front end drop down

Thank you in advance
Mauro
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:

My 'fields to retrieve' field

My returned sql

My front end dropdown

The desired front end drop down

Thank you in advance
Mauro
In fields to retrieve:
CONCAT(model.field , " - " , model.field2):model.aliasor
CONCAT(field , " - " , field2):aliasPay attention to the spaces between the commas.
This topic is locked and no more replies can be posted.