Re: Theory help needed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



i'm not experienced so this is just a theory.

if you have a parent id field in your tables then each reply would have
the parent id of the original message they replied to, so when your
program gets the data it will get the original message, and then get any
other messages with the same parent id, then it would move on and get
the next original message...etc.

e.g.
to get original message:

select message_body,message_id from message_table

then to get the threads of the original message:

select message_body,message_id from message_table where
parent_id=[message_id of original message]

i know thats a vague description but its an idea...i guess..


On Fri, 2002-12-20 at 15:23, Chris Payne wrote:
> Hi there everyone,
> 
> I have a messageboard which works, but what I need is some kind of threading for it.  Right now I have EXTREMELY basic threading, where you can reply to a message, reply to replies etc ..... and they'll appear in the correct part of the messageboard.  What I need though is to be able to do proper threading, where each reply appears under the original message and not all over the place, but i'm confused as hell.
> 
> Anyway have any experience with this kind of thing and can give me a push in the right direction?  I know I need to store the original ID, the forum ID, the message ID of the current message and the ID it relates to, but it's getting confusing :-)
> 
> Thanks.
> 
> Chris

Attachment: signature.asc
Description: This is a digitally signed message part


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux