AND/OR statement

[micmac]

Hi all,
Can anyone tell me how to better write the following code?

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

I'm having trouble getting the "OR" statement correct.

Cheers,
micmac

[TTT]

and (country= '' OR country='uk')