Advice for the correct syntax?
Posted: Wed Jul 11, 2012 8:37 pm
Hi all,
i any advice for the correct syntax for this. iknow you read it and understand it.
Thanks
i any advice for the correct syntax for this. iknow you read it and understand it.
Code: Select all
("SELECT DISTINCT COUNT(item_name),cat_id,productid FROM tbl_itemdescription WHERE cat_id = '$cat' GROUP BY item_name HAVING COUNT(item_name) = '1' ORDER BY item_name "); Thanks