#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    44
    Rep Power
    11

    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?
  2. #2
  3. Hello World :)
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2003
    Location
    Hull, UK
    Posts
    2,537
    Rep Power
    69
    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

  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    44
    Rep Power
    11
    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.
  6. #4
  7. Hello World :)
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2003
    Location
    Hull, UK
    Posts
    2,537
    Rep Power
    69
    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.
    programming language development: www.netytan.com Hula

  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    44
    Rep Power
    11
    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.
  10. #6
  11. Hello World :)
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2003
    Location
    Hull, UK
    Posts
    2,537
    Rep Power
    69
    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.
    programming language development: www.netytan.com Hula

  12. #7
  13. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    44
    Rep Power
    11
    Close enough

IMN logo majestic logo threadwatch logo seochat tools logo