Jump to content

query problem: returns wrong results


McMaster

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/207156-query-problem-returns-wrong-results/
Share on other sites

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.