Why doesnt this mySql query work?

Hi,

I cant get this MySql query to work:

$query = "SELECT * FROM `engines` WHERE name LIKE '$keyword%' AND languages='au' OR language='en' ORDER BY hits DESC ";

PHP:

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

 

Enclose the two in parenthesis.

$query = "SELECT * FROM `engines` WHERE name LIKE '$keyword%' AND (languages='au' OR language='en') ORDER BY hits DESC ";

PHP:

 

Doesnt work :/

 

I noticed some king of typo:

Which one is right?

 

Do you place mysql_query("SQL here") or die (mysql_error()) when your developing?

Glen

 

Thanks alot! I didnt notice that