How to make a forum list?

I asked this a while back, but got no replies. So, I'll ask again...

Can someone please write for me a simple little script that will list (echo or print) a list of all the forums in the message board? Each forum should be listed as a hyperlink to that forum.

For why I need this, please look at my message board: http://www.jjr512.com/bbs/index.php

Notice that at the top of the message board, and on the top of every message board page (forum list, thread list, thread view, etc.) there are hyperlinks into each forum. Many users like to use these, because they can hop around the forums quicker with these than with anything else. I manually created these links, and I'd just like something that will do it automatically, in case my forums change.

You dont have to edit the database at all to run something like this.

how do I add this custom field with php code?
can you please include better instructions on how to install it, and what to edit?

[Edited by Scaramanga_gold on 01-01-2001 at 12:49 PM]

Originally posted by vBoard.co.uk
You dont have to edit the database at all to run something like this.

You don't but I did because I got tired of having to update this small code snippet every time we added a forum to the system. So this way, I added a couple of fields to the table and set them when I create the new forum and everything just adjusts around it.

We currently have 19 public forums and 6 private forums for community Management. There are also 9 categories. If I add more (I have two forums that could be broke up right now) then I would have to change the code, however with my method, I don't. This also makes it easy for the other Administrator who doesn't touch the code to know that things are kept up to date and allows our Network Administrator to know that the listing is correct as we want it.

p.s. The other field I added allows you to turn post counting on and off per forum.

Originally posted by Scaramanga_gold
how do I add this custom field with php code?
can you please include better instructions on how to install it, and what to edit?

[Edited by Scaramanga_gold on 01-01-2001 at 12:49 PM]

It was meant more as a starting point so that you could create your own file. Other than creating the column in the Forum table and editing the Catagory select, there isn't anything else to install.

I would suggest making the column using phpMySQLAdmin as it is easiest this way.

Originally posted by JJR512
Actually, here's another question: Can we exclude forums that are either really Archives, or else are just closed?

$query = "SELECT * FROM forum WHERE Active=1 ORDER BY title ASC";

add the WHERE Active=1 and it will only show the active forums...