AND & OR sql query together please help?

eukhost

Hello,

I need an AND & OR query together and do not know how to do this. My code is below:

$result = mysql_query("SELECT * FROM products WHERE category='$category' OR name LIKE '%$keywords%' OR manufacture LIKE '%$manufacture%' OR price BETWEEN '$minprice' AND '$maxprice' ORDER BY price AND name limit $limit1,$limit2") or die (mysql_error());

So basiclly where it says or it needs to be AND, OR

Please can anyone help

Thanks

berbbrown

SELECT * FROM products WHERE category='$category' OR name LIKE '%$keywords%' OR manufacture LIKE '%$manufacture%' OR price BETWEEN '$minprice' AND '$maxprice' ORDER BY price AND name limit $limit1,$limit2"

I always thought that the ORDER BY element was placed at the end of a SQL Query after the criterion selection. Therefore:

SELECT * FROM products WHERE (category='$category' OR name LIKE '%$keywords%' OR manufacture LIKE '%$manufacture%' OR price BETWEEN '$minprice' AND '$maxprice') AND (name limit $limit1,$limit2") ORDER BY price