in reply to Re: message board thread quandary
in thread message board thread quandary

So you do use two tables with this set up?

meh.

Replies are listed 'Best First'.
Re^3: message board thread quandary
by Your Mother (Archbishop) on Sep 07, 2007 at 04:58 UTC

    Only because the posts are threaded too. It's not necessary to have another table otherwise (well, except for users and whatever you want attached). The comments are threaded in and of themselves. It just happens to be a blog package so they are also attached to a post. If it were for a forum, they'd be standalone in their table and any without a parent would be the first in a thread.

      I'm a little confused then, perhaps you could help me out and explain how I set up a relationship within the post/blog table to retrieve the replies to replies correctly as you've done in your code. I don't quite grok how that is done.

      meh.