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 ";

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

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

Thanks alot!

Hi

I am having trouble with this code:

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

It is the languages='$lang' that dont work..

$lang =

'Finnish' OR languages='Italian' OR languages='German'

I think it has something to do with double ' symbols, but I dont know how to solve it :/

Anyone know?

Thanks in advance

Echo the entire query -- but you'll get in less trouble if you use IN().