Hi Folks,

I am developing forums for a site. I just want to know what should be the table structure for storing the messages which are hierarchical i.e reply to a reply, reply to the second reply and so on.

Also how to display each message under the parent message.

The table structure I think of is

Replyid|ForumID|TiTle|Message|MessageIcon|ParentReplyID|ReplyDate|ReplyModificationDate|

ParentReplyID is the Replyid under which a particular message will come.

But the problem is how to display them under the proper parent.

Please enlighten me.

Regards,

Samir