How to display num_rows() and result() in the same Foreach loop

[eluser]kgill[/eluser]
In your query left outer join your categories table to your posts table, selecting a count of posts and the category, group by category. That will give you data like so:

Code:

catname postcount
------- ---------
cat1    12
cat2    4
cat3    0

Then just loop through the rows in a foreach displaying row->catname (row->postcount) in your li's.