On Monday 20 June 2005 04:54 pm, Chris Payne wrote: > For example, I know I need ID, messageid, forumid and messagerootid (Just > example names) but I'm not sure of the theory of how replies to replies etc > ... would work in PHP with MySQL? I guess I'm just confused on the whole > threading business and I'm just looking for some good explanation of how I > can easily add threading to my messageboard (Assuming my messageboard is > just an average system which adds the ID as an auto-numerator, the > messageid and all subject etc ...). >
What I usually do in the interest of just keeping things simple, is to just have a message ID, and parentID. You can then calculate the root message (select * from messages where parentID = 0) and get children from there (select * from messages where parentID = $messageID) Anytime a reply is made, just make the original messageID the parentID of the reply. This makes unlimited threads which leads to some formatting issues (if you're indenting for each reply, for example, you must limit the indenting at some point) but that's a seperate issue. Hope that helps, -Micah -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
