Custom SQL Fields read more query lines

Hi Tuan

Thanks for the help on sql.zip getting the current user_id, I get now all data on register for the user who register.
How can I add different query lines in an sql field?

It is very important for us because our families have many children, and we have structured it in many different fields to cover all cases.

We have 4 fields for the first birth, because there are families that have twins, other triplets and there may be some quadruplets.
In addition we have other four fields that cover a second multiple birth. With 4 other camps for different children. We have families with tiwns and triplets in two birds
And also our families have up to 6 non-multiple children (we have 8 other camps to cover possible large families) There are some families that it has :S plus twins
In total we have more than 16 different fieds for family children.

It is a little difficult for the one who registers to search among all those fields to select their children.

How can I create a selection list using sql queries to display only the children of each user?

I think you just have to make an array of the different queries (discarding the empty ones) to add them to that list. Would it be possible?


Thanks in advance

Sorry Carmen. For that, you would have to customize the code of the file yourself. You need to look at the file sql.php which we provided and work on further modifications

The [USER_ID] field is still not working properly. it works when someone sign up, but when admin edit the record, it won't work properly

I will find a solution for that problem. For multiple queries, please try to customize the code yourself

Regards,

Tuan

Ok Tuan

I will try to find someone to adapt me the code.

Please, when you know something new about the User_Id Field, please let me know


Thank you