query problem: returns wrong results

[McMaster]

Hey,

 

I have created a search on my website and it works fine but the problem is that it searches through all categories rather than the one selected from the drop down. I echoed the query result and this is what I got

 

select * from products where category = 'games' AND title LIKE '%broken%' OR description LIKE '%broken%' OR title LIKE '%sword%' OR description LIKE '%sword%' 

 

Any ideas as to why it's not searching with the category games but instead shows results for every category?

 

Thanks in advance

[Mchl]

Is 2 + 3 * 5 equal to (2+3) * 5 ?

 

Same goes for

 

a OR b  AND c  vs (a OR b) AND c

[McMaster]

Spot on mchl. Thanks a lot for that. Changed to:

 

select * from products where ( title LIKE '%broken%' OR description LIKE '%broken%' OR title LIKE '%sword%' OR description LIKE '%sword%' ) AND category = 'Anti-Acne' 

 

Worked a treat.