Page 1 of 1

Why doesnt this mySql query work?

Posted: Fri Aug 27, 2010 6:17 pm
by dominod
Hi,

I cant get this MySql query to work:

Code: Select all

$query = "SELECT * FROM `engines` WHERE name LIKE '$keyword%' AND languages='au' OR language='en' ORDER BY hits DESC ";
It is the AND languages='au' OR language='en' part which I cant get to work I think.. I want it to select it IF language is either 'en' OR 'au'...

Thanks in advnace :)

Re: Why doesnt this mySql query work?

Posted: Fri Aug 27, 2010 6:37 pm
by Jonah Bron

Code: Select all

$query = "SELECT * FROM `engines` WHERE name LIKE '$keyword%' AND (languages='au' OR language='en') ORDER BY hits DESC ";
Should work. Specify logic hierarchy with parentheses.

Re: Why doesnt this mySql query work?

Posted: Sat Aug 28, 2010 5:02 am
by dominod
Thanks alot! :)