Processing query data to produce craigslist style categories with row counts.

[eluser]Hannes Nevalainen[/eluser]
You need to join your tables =)

It can be little tricky at first but it's really worth digging in to it! =)
Find a nice tutorial on this (google for tutorial mysql join) and you will get lucky ^^

Happy Coding =)