PDA

View Full Version : pulling forum info


Ninth Dimension
03-27-2002, 03:30 PM
Hi all, take a quick look at my forums front page (http://bbs.ofdan.net/) 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
03-28-2002, 08:16 AM
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