Forum data storage

Dev Shed Forums Sponsor:

May 20th, 2004, 05:04 AM

flixxer

Contributing User

Join Date: Feb 2004

Posts: 44

Time spent in forums: < 1 sec
Reputation Power: 10

Forum data storage

How to store data(post) for buletin board system using mySQL?
Did you need to use 1 table per thread? or any other ways?

May 20th, 2004, 07:09 AM

netytan

Hello World :)

Join Date: Mar 2003

Location: Hull, UK

Posts: 2,537

Time spent in forums: 1 Week 2 Days 18 h 17 m 47 sec
Reputation Power: 68

I'm comfused... But theoretically you can set a table up so that each thread is just an entry linked together using group ID's.

Hope this helps,

Mark.

__________________
programming language development: www.netytan.com – Hula

May 20th, 2004, 07:22 AM

flixxer

Contributing User

Join Date: Feb 2004

Posts: 44

Time spent in forums: < 1 sec
Reputation Power: 10

I'm thinking about this way:

Code:

table : thread 1
++++++++++++++++++++++++++++
+ id  + Subject  + Post    +
++++++++++++++++++++++++++++
+ 1   + anything + post    +
++++++++++++++++++++++++++++

the entry with id #1 will be the mainthread/title, and other entries as posts in that thread, possible?

Last edited by flixxer : May 20th, 2004 at 07:25 AM.

May 20th, 2004, 07:30 AM

netytan

Hello World :)

Join Date: Mar 2003

Location: Hull, UK

Posts: 2,537

Time spent in forums: 1 Week 2 Days 18 h 17 m 47 sec
Reputation Power: 68

But that would require you to have a table for each post would it not; assuming that id is the 'primary key'.

Are we talking about a multiple messages to a thread or just a flat thing?

Mark.

May 21st, 2004, 04:04 AM

flixxer

Contributing User

Join Date: Feb 2004

Posts: 44

Time spent in forums: < 1 sec
Reputation Power: 10

I found that areally stupid way of dealing with this thing, if the board is working on real world then it will ended up with tons of table in the database.

May 21st, 2004, 10:19 AM

netytan

Hello World :)

Join Date: Mar 2003

Location: Hull, UK

Posts: 2,537

Time spent in forums: 1 Week 2 Days 18 h 17 m 47 sec
Reputation Power: 68

I dont concure on that one, i set up a simple muti-threaded message board in PHP when i first started out and the way i worked it we were using a single table for each forum. Replies being linked to their parent thread using ID's. Is this not what your wanting to do?

Mark.

May 22nd, 2004, 04:23 AM

flixxer

Contributing User

Join Date: Feb 2004

Posts: 44

Time spent in forums: < 1 sec
Reputation Power: 10

Close enough

Forum data storage

Developer Shed Advertisers and Affiliates