[PHP-DB] Best way to multi-thread (Kind of)?
Hi there everyone, I have almost finished my forums system (Thanks for the feedback BTW on optimizing the basic query code). Now that works fine on all 6 forums (Though i've programmed the 6th forum differently to allow image uploading and resizing). My question is this, I want people to be able to reply to a message and for any messages that have replies to have them indented UNDER the original for selection, how can I do this? I know I need a reference to the original message, but i'm not sure how to do the indenting etc and getting it to display under the original posters message. Any help would be VERY welcome. Regards Chris Payne
Re: [PHP-DB] Best way to multi-thread (Kind of)?
For each message have a autoincrement message ID, an INT field is sufficient I would guess. Also in each message record, have a parentID field as INT, default this to 0, and if the message is a reply to another message, make the parentID = to the first message's ID field. When you're displaying titles, query for all messages that have parentID of 0, then for each one of those, do a second query for a parentID of that message ID. I hope that explanation isn't too convoluted. I'm sure there's other possibly better ways to do it, but that's how I've done it in the past. -Micah On Monday 18 August 2003 6:21 pm, Chris Payne wrote: Hi there everyone, I have almost finished my forums system (Thanks for the feedback BTW on optimizing the basic query code). Now that works fine on all 6 forums (Though i've programmed the 6th forum differently to allow image uploading and resizing). My question is this, I want people to be able to reply to a message and for any messages that have replies to have them indented UNDER the original for selection, how can I do this? I know I need a reference to the original message, but i'm not sure how to do the indenting etc and getting it to display under the original posters message. Any help would be VERY welcome. Regards Chris Payne -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Best way to multi-thread (Kind of)?
Hi there, Ahhh you're a life saver, thanks for that that really helps out alot - and makes sense when I think about it :-) Regards Chris For each message have a autoincrement message ID, an INT field is sufficient I would guess. Also in each message record, have a parentID field as INT, default this to 0, and if the message is a reply to another message, make the parentID = to the first message's ID field. When you're displaying titles, query for all messages that have parentID of 0, then for each one of those, do a second query for a parentID of that message ID. I hope that explanation isn't too convoluted. I'm sure there's other possibly better ways to do it, but that's how I've done it in the past. -Micah On Monday 18 August 2003 6:21 pm, Chris Payne wrote: Hi there everyone, I have almost finished my forums system (Thanks for the feedback BTW on optimizing the basic query code). Now that works fine on all 6 forums (Though i've programmed the 6th forum differently to allow image uploading and resizing). My question is this, I want people to be able to reply to a message and for any messages that have replies to have them indented UNDER the original for selection, how can I do this? I know I need a reference to the original message, but i'm not sure how to do the indenting etc and getting it to display under the original posters message. Any help would be VERY welcome. Regards Chris Payne -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php