mySQL query not filtering

[petenaylor]

Hi all

 

The following piece of code doesn't just bring back results where live = 1 it shows all results?

 

Am I doing something wrong?

 

$getproducts = mysql_query(" SELECT * FROM products WHERE live = 1 AND title LIKE \"%$term%\" OR description LIKE \"%$term%\" ORDER BY id DESC ");

[dmikester1]

WHERE live = 1 AND title LIKE \"%$term%\" OR description LIKE \"%$term%\"

 

What do you want here?

WHERE (live = 1 AND title LIKE \"%$term%\") OR description LIKE \"%$term%\"

- or -

WHERE live = 1 AND (title LIKE \"%$term%\" OR description LIKE \"%$term%\")

 

Notice the change in parens.

Mike

[awjudd]

You are missing brackets, so the order of operations isn't working as you wanted.

 

$query="SELECT * FROM products WHERE live = 1 AND (title LIKE '%$term%' OR description LIKE '%$term%') ORDER BY id DESC";

 

~awjudd