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.
FrontEndUser: probleme select user
-
- New Member
- Posts: 5
- Joined: Wed Nov 12, 2008 11:23 am
FrontEndUser: probleme select user
Last edited by khaled_isamm on Sat Jan 24, 2009 12:22 pm, edited 1 time in total.
Re: FrontEndUser: probleme select user
Hi
Could you please be more specific?
What is your goal?
JanB
Could you please be more specific?
What is your goal?
JanB
-
- New Member
- Posts: 5
- Joined: Wed Nov 12, 2008 11:23 am
Re: FrontEndUser: probleme select user
HIjanb wrote: Hi
Could you please be more specific?
What is your goal?
JanB
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 ; !!!!!!!!!
