AND/OR SQL Statement

[micmac]

Hi all,
If i have the following code:

$result = mysql_query("SELECT * FROM cat1 WHERE CatParent = $id AND active='yes' AND country IN('', 'AUS') ORDER BY pref,CatName");

how can i add another AND/OR statement for country that checks if the value is 'ALL' ('ALL' is another value that the country field could be)

Any ideas,
micmac

[Traduim]

It should work:

$result = mysql_query("SELECT * FROM cat1 WHERE CatParent = $id AND active='yes' AND (country IN('', 'AUS') OR country = 'ALL') ORDER BY pref,CatName");

If that's what you want to do.