Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/massagec/public_html/dispcategory.php on line 75
Could not run query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ListingType = 'p' AND cart_categories_items.ItemID = cart_items.ItemID ' at line 6
SELECT cart_items.*, COUNT(VariantID) FROM cart_categories_items, cart_items, cart_items_variants WHERE CategoryID = AND ListingType = 'p' AND cart_categories_items.ItemID = cart_items.ItemID AND cart_categories_items.ItemID = cart_items_variants.ItemID AND ItemInStock <> 'H' GROUP BY cart_items.ItemID ORDER BY cart_categories_items.CatItemSeq