CMS Made Simple Forums

hi
i have a problem with  FrontEndUser module
when I try to select a user of the list with 2 or more properties in my request (WHERE data like... AND data LIKE....)

module_feusers_properties table:

id userid title              data
18 1         image         1_image.jpg
17 1         fonction      docteur
16 1         mail            user(at)user.com
15 1         tel              123465
14 1         name          user
13 1         lastname    user

please help.

Hi

Could you please be more specific?
What is your goal?

JanB

janb wrote: Hi

Could you please be more specific?
What is your goal?

JanB

HI
thanks for the reply

I try to search for users by name, phone, mail,...
for exp: I will look for the user that his name is janb and his phone is 123456
exp: SELECT * FROM `module_feusers_properties`WHERE  `title` = 'name' AND 'data' LIKE 'JanB' AND `title` = 'phone' AND 'data' = 123465 ; !!!!!!!!!