View Full Version : table structure for creating a forum

03-21-2007, 07: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:

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





03-21-2007, 08: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.