Why doesnt this mySql query work?

[dominod]

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

[trq]

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

[dominod]

Thanks alot!

[dominod]

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

 

 

[fenway]

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