Only display populated categories

[eluser]GrahamDj28[/eluser]
Here is a query that could help you.

Code:

SELECT c.*, i.*
FROM category AS c
LEFT JOIN item AS i ON i.cat_id = c.id

This should return only categories that have items, and it will also contain the items. If you only want the categories, then remove i.* from the select