Left Join, text search query Problem

[weby]

This looks like a forum with a lot of knowledge, hope you can help me with my issue or point me in the right direction..

 

I'm trying to search for a login name that fits to either one of 3 search terms: login (username), email or distributornr.

I have 2 tables amember_members and profile with the members_id being the same in both tables.

The search comes from a form with one field name search so thats the variable $search

 

My code looks like this:

 

$sql="SELECT amember_members.login, amember_members.email, profile.distributornr FROM amember_members LEFT JOIN profile ON amember_members.member_id = profile.member_id WHERE login LIKE '$search' OR distributornr LIKE '$search' OR email LIKE '$search'"; 
$rs=mysql_query($sql) or die(mysql_error());
$num=mysql_num_rows($rs);

 

This is the error message I get.

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'login LIKE 'test' OR distributornr LIKE 'test' OR email LIKE 'test'' at line 1

 

Maybe it's easier then I think to solve this.. but I've tried with various ways of coding.. and I just cant get it right.

Let me know if you need more info.

[toplay]

Don't forget the percent signs. Try something like this:

 

$sql="SELECT m.login, m.email, p.distributornr FROM `amember_members` m LEFT JOIN `profile` p USING (member_id) WHERE m.login LIKE '%$search%' OR p.distributornr LIKE '%$search%' OR m.email LIKE '%$search%'";