pulling forum info

Hi all, take a quick look at my forums front page and then come back to the question. don't worry, i'll wait for you...

*tum de tum*

ok, you're back, good.

Right, you see the 4 images, these all link off to the main rooms of the forum, but if you ask me it's looking a little bland, so I wanted to spice it up a little by putting some room stats (i.e. number of posts, threads, last post time, etc...) but I don't have a clue how to do it, and as each of these rooms is just a catagory, with a bunch of forums under it I don't know what query I would use to pull the info about that room, and that room only.

Any help you can supply me with will be totally apprechated.

(PS, if I can get my idea of rooms on the forum running fully, then I'll release it as a hack )

[Admin]

replycount = total posts;
threadcount = total threads;
lastposter = name of last poster;
lastpost = time of last post (in unix timestamp);

SELECT replycount,threadcount,lastpost,lastposter FROM forum WHERE forumid=XX