Mysql search query

[Melter]

I can't work out how to stop some items being called in a mysql search. What I've tried is:

$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?

[Barry]

Try

$sql -> db_Select("store", "*", "(masterCategoryID = '1' AND advertiser <> 'Widgets') order by RAND()");




might work

[Melter]

Well that seems to work nicely. Cheers Barry.