help to query for sql field

Hello i need help to create the query for a sql field that pulls out the list of the name of the registrants of the event to which I am registering now (I need to indicate the parent of a minor who is registered at the event).
Thank you

Hi

1. You will have to create a new SQL custom field, assign it to that event, so for each event like this, you will have to create a SQL Command

2. Try to use the SQL command below:

SELECT CONCAT(`first_name`, ' ', `last_name`) as value, CONCAT(`first_name`, ' ', `last_name`) AS text FROM #__eb_registrants WHERE event_id = 100 AND published = 1

(Replace 100 in the SQL command above with ID of the event you are registering for)

Then check the result, it should work as expected

Regards,

Tuan

thank you very much, it works perfectly!

Great. Happy to heart that and thanks for confirming

Regards,

Tuan