Get user id for SQL custom field

This worked perfectly, thanks so much!

Hi All

We are in the same situation.

Our association is composed of families with multiple children (twins, triplets ..). In our free activities only the children of each family can be registered, and they are always the same.

We need to know how to find the name of a child by the membership number.

In the sql Query we are testing, we look for the child's name and add the year and month of birth (some activities depend on the child's age)

I do not program in php and I do not know how to modify the sql.zip file that I have added in this post to get current user_id

Our SQL Query we use:

SELECT CONCAT (`cb_hijo1pm1`, ', ', LEFT(`cb_fechapartomultiple1`, 7)) as value, CONCAT (`cb_hijo1pm1`, ', ', LEFT(`cb_fechapartomultiple1`, 7)) as text from `#__comprofiler` WHERE cb_numerodesocio = 1747 ( we need to get here current loged $user_id )

This Query gets this Result: Carolina, 2009-03 ( for example)

With this php (php.zip) we can select from a list, but we can´t add a second line on SQL Query (field default values) (dont work) to make a list from diferents Childs from a family.


We have other problems that we do not know how to solve, but i will open another topic to ask about.


Thanks in advance and sorry for my English

Any help Please?

Sorry. I have been so busy today and could not look at this question and answer. I will look at it on tomorrow (too tired now to look at it)

Tuan

Hello

Please try the solution below:

1. Get this file, unzip it, upload it to administrator/com_eventbooking/libraries\rad\form\field folder

2. Then in the SQL command, you can use the tag [USER_ID] . It will be replaced with ID of the logged in user

Actually, I think there is still problem. That will only works when users to register. When admin view the registration record for example, it will be replaced with ID of admin, so we will still have problem

Need better solution. Will try to have a solution for you on Monday

Regards,

Tuan