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

Reply via email to