forum making
Moderator: General Moderators
-
method_man
- Forum Contributor
- Posts: 257
- Joined: Sat Mar 19, 2005 1:38 am
forum making
i am making a forum and i am wondering what fields i would need for the table in my database.
would i just need:
users
password
posts?
or would i need anything else
thanks,
matt
would i just need:
users
password
posts?
or would i need anything else
thanks,
matt
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
-
method_man
- Forum Contributor
- Posts: 257
- Joined: Sat Mar 19, 2005 1:38 am
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
-
method_man
- Forum Contributor
- Posts: 257
- Joined: Sat Mar 19, 2005 1:38 am
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
What I suggest doing is firstly spending a good while thinking about EVERYTHING you want to have included in the forum... (account types, show email, msn yahoo aim etc, different boards, ip tracking, etc etc etc). Then you'll need to decide exactly what needs storing to do that. Finally you'll have to normailize that to at least 3NF (according to Codd's Rules -> Google it).
If you read up on database normalization this task will not seem quite so overwhelming
You're gonna end up with quite a lot of tables if you're looking for an efficient and highly functional forum...
I'd *possibly* help you set the database up (not in the next few days mind-you) but then you'll need to understand how to join everything back up when you retreive the data....
If you read up on database normalization this task will not seem quite so overwhelming
You're gonna end up with quite a lot of tables if you're looking for an efficient and highly functional forum...
I'd *possibly* help you set the database up (not in the next few days mind-you) but then you'll need to understand how to join everything back up when you retreive the data....
- Ambush Commander
- DevNet Master
- Posts: 3698
- Joined: Mon Oct 25, 2004 9:29 pm
- Location: New Jersey, US
-
method_man
- Forum Contributor
- Posts: 257
- Joined: Sat Mar 19, 2005 1:38 am
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Well your on phpBB right now... it's free and open source and available at http://www.phpbb.com/ (linked to in the page footer)method_man wrote:where would i download a forum?
Other common ones are Invision Board and vBulletin...