Query Doesn't Return What I Want

[refiking]

I am trying to get only the records with the same users_id as the variable, but it returns all of them.  And for the record, the db table doesn't have any records with the users_id I use as the variable currently, so mysql_num_rows() should be 0.  What am I doing wrong?

 

$sql = mysql_query("select * from my_contacts where users_id = '$users_id' or first_name LIKE '%".addslashes($keyword)."%' or last_name LIKE '%".addslashes($keyword)."%' or direct_number LIKE '%".str_replace('-', '',addslashes($keyword))."%' or office_number LIKE '%".str_replace('-', '',addslashes($keyword))."%' or fax_number LIKE '%".str_replace('-', '',addslashes($keyword))."%' or company_name LIKE '%".addslashes($keyword)."%' or company_city LIKE '%".addslashes($keyword)."%' or email LIKE '%".addslashes($keyword)."%' or secondary_email LIKE '%".addslashes($keyword)."%'");

[abazoskib]

try this:

 

$sql = mysql_query("select * from my_contacts where users_id = '$users_id' AND ( first_name LIKE '%".addslashes($keyword)."%' or last_name LIKE '%".addslashes($keyword)."%' or direct_number LIKE '%".str_replace('-', '',addslashes($keyword))."%' or office_number LIKE '%".str_replace('-', '',addslashes($keyword))."%' or fax_number LIKE '%".str_replace('-', '',addslashes($keyword))."%' or company_name LIKE '%".addslashes($keyword)."%' or company_city LIKE '%".addslashes($keyword)."%' or email LIKE '%".addslashes($keyword)."%' or secondary_email LIKE '%".addslashes($keyword)."%')");