I have tried this and it doesnt work...
SELECT ProductID, ProductSKU, ProductName, ProductPrice, ProductWeight, ProductCartDesc, ProductLongDesc, ProductImage, ProductImage2, ProductImage3, ProductImage4, ProductLive, ProductCategory
FROM products
WHERE ProductID = colname
GROUP BY ProductCategory
its still showing the selected category twice......