[SOLVED] Php Mysql query problem (WHERE and WHERE) !

[nita]

Hi

I would like to do query which is searching only records with "Menuideas" in subcategory column.

 

my code is :

$result1 = mysql_query("SELECT * FROM recipe WHERE subcategory='Menuideas' and WHERE name LIKE '%$search%' OR ingred LIKE '%$search%' ORDER BY name LIMIT $offset, $rowsPerPage");

 

i'm not sure if WHERE and WHERE is the correct syntax in this case ??

 

Need some help with this one... please

 

Nita

[nita]

i fixed the code (little bug)

 

$result1 = mysql_query("SELECT * FROM recipe WHERE subcategory='Menuideas' AND name LIKE '%$search%' OR ingred LIKE '%$search%' ORDER BY name LIMIT $offset, $rowsPerPage");