I am stumped on a basic question. I am trying to query items out of a database but leave out just one specific item and all blanks. Unfortunately all the items are still showing including the blanks and the 'General' category I dont want to see. Anyhelp will be appreciated.
my query looks something like this:
$findmatch=mysql_query("SELECT item_category,COUNT(item_category) AS catCount FROM classifieds WHERE ".$strSearchItemX." AND item_category!='General' AND item_category!='' GROUP BY item_category LIMIT 10");
$strSearchItemX is automatically generated line which looks like this:
item_description LIKE '%Dear%' OR item_category LIKE '%Dear%' OR item_description LIKE '%friend%'
my query looks something like this:
$findmatch=mysql_query("SELECT item_category,COUNT(item_category) AS catCount FROM classifieds WHERE ".$strSearchItemX." AND item_category!='General' AND item_category!='' GROUP BY item_category LIMIT 10");
$strSearchItemX is automatically generated line which looks like this:
item_description LIKE '%Dear%' OR item_category LIKE '%Dear%' OR item_description LIKE '%friend%'