title: Multi Threaded Comments PHP?
body: <p>I have a script I wrote I while back for comments, but it is only single threaded. I would like it to be multi-threaded, but only as so a user can reply to a comment, not so a user can reply to a comment of a comment. So the threads would only be two deep.</p>
  
  <p>Currently I store a <code>comment_id</code> against a <code>user_id</code> in my database. </p>
  
  <p>The only way I can think of to do the multi threaded comments, is to have a <code>parent</code> field in the comments table. But if I do this then when I am selecting the comments with PHP, I will have to do another SELECT command to select the comments children (if any) for each comment. Seems like a lot of work on the database.</p>
  
  <p>There has to be a better way. Any ideas on this? Or tutorials? </p>