View Full Version : Forums - Categories :S

05-04-2004, 07:08 PM
ok one thing that i do not understand one bit is how to create a forum with categorys, i know you have to use primary keys etc but i dont know how the variable reads this and im all confused please cna some1 explain it in baby steps? thanx :thumbsup:

05-04-2004, 07:38 PM
Well here is the basics how I would go about it (Im doing the very basics here):

Create a category table, eg:

categoryId | categoryName

Then create a forums table:

forumId | forumName | forumDescription | forumInCategory

And have forumInCategory relate to categoryId, so if categoryId = 1, all forums with the value forumInCategory = 1 would be in that category.

Sorry for being so vague, but im a bit busy, and Im not 100% sure i have the right idea.

(also, just a minor criticisim, your topic name could have been slighly more descriptive, would you be able to edit it a bit so it better describes your problem?)