Add More Where In Query

[lovephp]

is it possible that i add another WHERE clause to this query?i want to add where user=$username ??

 

 

$results = mysql_query("SELECT * FROM table
WHERE (`phone` LIKE '%".$query."%')
OR
(`name` LIKE '%".$query."%')")
or
die(mysql_error());

[lovephp]

or is this right, oh and the user is stored in session so i want it to display results according to users name

$results = mysql_query("SELECT * FROM table
WHERE (`user= ".$user."')
AND
(`phone` LIKE '%".$query."%')
OR
(`name` LIKE '%".$query."%')")
or
die(mysql_error());

Edited November 16, 2012 by lovephp

[DavidAM]

You need to group the OR part together (if that is what you want)

 

WHERE user = 'username'
AND ( phone = 'phone'
 OR name = 'name'
 )

This requires the user to match and either the phone or name to match.

[lovephp]

so i do not need to use the LIKE clause to do the search?

[DavidAM]

You should use LIKE if you need LIKE. I was just showing the structure to use when you need an AND along with an OR. Since AND and OR have the same precedence, they are evaluated from left to right (or top to bottom). If you have: "Condition1 AND Condition2 OR Condition3" it evaluates differently than having: "Condition2 OR Condition3 AND Condition1". So you use the parenthesis to make sure the conditions are evaluated the way you want: "Condition1 AND (Condition2 OR Condition3)" (which is also evaluated differently from either of the other two).