mysql query AND OR

[mediamind]

What is wrong with this query?

It returns the correct results, but it does not take in account the prod_web='ja' it returns everything.

mysql_query("SELECT * FROM products WHERE prod_web='ja' AND prod_naam LIKE '%$searchstring%' OR prod_k_omschr LIKE '%$searchstring%' OR prod_l_omschr LIKE '%$searchstring%'") or die (mysql_error());

Kind regards,
Gerry.

[chowdary]

Hi Gerry,
It looks something wrong with AND & OR conditions , I am not sure whether this works for you but,try

mysql_query("SELECT * FROM products WHERE prod_web='ja' AND (prod_naam LIKE '%$searchstring%' OR prod_k_omschr LIKE '%$searchstring%' OR prod_l_omschr LIKE '%$searchstring%')") or die (mysql_error());

Notice that i added braces

[mediamind]

Thanks for you quick reply...

Kind regards,
Gerry

[spider_man]

Your query behaved like that because the AND has greater precedence than OR.