cultstuffstore.com


Notice: Trying to get property of non-object in /usr/home/csstore/public_html/templates/masthead.php on line 70

Top Ten TV Show Gifts

The selection of our most popular tv show based gifts.



Notice: Undefined variable: array in /usr/home/csstore/public_html/tv-show-gifts.php on line 24

Warning: Invalid argument supplied for foreach() in /usr/home/csstore/public_html/tv-show-gifts.php on line 24

Can't execute query

SELECT DISTINCT
		 p.id
		,p.name
		,p.description_short
		,p.pix_small
		,p.price
		,p.on_special
		,p.nodiscount
		,v.maxprice
		,v.discount
	    ,p.venue
		,p.merchant
		,p.clicks
		,pc.category_id
	FROM
		 products p
		 ,vendor v
		,products_categories pc
	WHERE ((p.id = pc.product_id) AND (p.vendorid = v.vendorid)) and p.suspend<>1
		AND pc.category_id IN ()
	ORDER BY p.clicks DESC
	LIMIT 10

MySQL Error: 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 ') ORDER BY p.clicks DESC LIMIT 10' at line 20

This script cannot continue, terminating.