...

View Full Version : table structure for creating a forum



skirmish
03-21-2007, 06:39 PM
hey guys,

I have written most the code for a basic forum, but i would like to introduce catagories into the forum and wondered someone could help me get my head around the mysql table structure needed.

Any help much appreciated....:thumbsup:

skirmish
03-21-2007, 06:51 PM
To my understanding so far i'm going to need three tables, these being:

-categories

-topics

-replies

right?

Inigoesdr
03-21-2007, 07:13 PM
You could do it that way(I think phpBB does) or you could use a categories tables and a posts tables. Just set the category id, a "original post" field to true if it's the first post. Then with the replies you would set the original post's id in another field.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum