I can't work out how to stop some items being called in a mysql search. What I've tried is:
Code:
$sql -> db_Select("store", "*", "masterCategoryID= '1' NOT advertiser= 'Widgets' order by RAND()");
So basically I want random items where masterCategory equals 1 but to stop any items it finds in advertiser Widgets. Any ideas?