Possible to get "number of threads started in a certain forum"?

[slip]

Okay, for reasons that are kinda hard to explain, It would be REALLY nice to be able to have it so that maybe in a users profile, or just only visible to admins, I could see how many threads a user started in one particular forum..


Actually, two forums would be best..
So somewhere I could see..

User Profile for Slip:
Threads started in Forum 1: Five
Threads started in Forum 2: Ten


could anyone help me here?

thanks a lot.. :)

slip

[Wayne Luke]

You would have to do a while loop through all forums doing a

SELECT COUNT(*) as count from thread where forumid=XX and userid=XXXX