ChronoEngine.com homepage

Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

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

mauropiro 11 Oct, 2018
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 12 Oct, 2018
In fields to retrieve:
CONCAT(model.field , " - " , model.field2):model.alias
or
CONCAT(field , " - " , field2):alias
Pay attention to the spaces between the commas.
mauropiro 12 Oct, 2018
Dear Healyhatman

It worked perfectly, you're awesome,

Thank you.

Mauro
This topic is locked and no more replies can be posted.

2Checkout.com

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by ChronoEngine.com