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
