Calculating total records from table

[asad]

Hi, I have some problem in showing data.

I have two tables
First table(containing Hosting categories)
Second table(Containing category data like url,keyword,description.....etc)

I want to display categories names from first table and then different categories
total records from second table, like this
ASP.NETHosting(10)
Linux Hosting(20)
Windows hosting(13)
:
:
:
etc


How could I do this pls tell me
THANKS

[redcircle]

1st what database are you using. 2nd what server side script are you using?

[paulhiles]

asad - I've moved your post into Database Talk, hopefully (as redcircle has suggested) you can provide us with more details of your database and the script being used.