Why wont this work?

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

PHP:

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

$lang =

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

PHP:

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

Anyone know?

Thanks in advance

 

Yea, it's the double single quote on languages='

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

PHP:

try this

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

PHP:

 

Didnt work

I also tried

$lang = "OR languages='Finnish' OR languages='Italian' OR languages='German'";

PHP:

which would be correct but got nothing :/

 

Its working now

Thansk alot!

 

Sorry didn't see the post above, please delete mods.

Thanks