show # of records next to categories

I'm searching the web and can't find any article explaining how to show # of records for each category. Maybe I'm not looking  right.

Example:
1. Category1 (5)
2. Category2 (4)
3. Category3 (0)

I'm using access db.


So if you guys know a site where can I find it, I would be cery happy .

Thanks,

Thanks for the script.

I have encounter a problem with some code and I hope if some1 will help me out.

I have made an ad script. Noe the thing is that u have to be a member of my forum to be able to add an ad.
This part is working.

The problem that I have is:
On the detail page....a visitor ( member ) can see the ad + a name of a member which has placed it.
As I was looking at pop_up_profile.asp page, I was hoping to add a link so that members can send each other an email if they are interested in
certain add.

This is th e part of code which I added to my detail page

<!--#include file="../forum/common.asp" --> <% Response.Write("<a href=""javascript:openInMainWin('email_messenger.asp?SEID=" & lngProfileNum & "')""><img src=""" & strImagePath & "email_button.gif""  border=""0"" align=""absmiddle"" alt=""" & strTxtSendEmail & """></a>") %>

Now, does any1 have any idea what else should I also add so that when some1 clicks on this link they could send an email....same as in forum.

Thanks,