SQL ERROR :
SELECT * FROM tbl_categories  WHERE status='1'  ORDER BY cname ASC
SQL ERROR :
SELECT subcat.*,count(subcat.id) as total
	FROM tbl_subcategories as subcat
	LEFT JOIN tbl_products as p
	ON subcat.id=p.psubcat_type
	WHERE subcat.cat_id='21' AND subcat.status='1' AND p.status='1' GROUP BY p.psubcat_type  
	ORDER BY subcat.name ASC

Rubber Planters

Sub Categories (1)

SQL ERROR :
SELECT * FROM tbl_categories  WHERE status='1'  ORDER BY cname ASC
Top