Search options (Page 3 of 6)

No, I designed the layout myself with punbb. Maybe you should look closer before making accusations.

Mezzyart will be better than deviantart

I've since changed the script, but I suppose I can get some sample entries. Just to clarify, you would like 20 to 30 sample entries to test with?

It didn't really work... I think your code was supposed to have $sb instead of $all in the loop. I'm needing one that threads them in such a way that there can be more than one comment on a single level. I think this can only be achieved with a recursive function... is there anything wrong with having over 40 queries? Probably...

This is difficult since I have a nested comments script that works, but the only problem is the number of queries.

Tobi, if you can come up with one that doesn't use a crapload of queries and still is completely functional (with ordering ASC and DESC by date) perhaps I can offer you something for it.

I should have explained more clearly.

I have a mysql table with the column names 'id' and 'my_parent'. The first comment always has a my_parent of 0 and an auto-incremented id. When someone replies to said comment, my_parent of the new comment is the id of the one it's in response to. (say that ten times fast)

With this information, a recursive function can be called to spit out the comments.

something like

function comment_list($id){
//get comment information for comment with the value $id with a query containing  the count() command

$query= $db->query("SELECT *, count(blah) AS replies FROM comments ...blah blah blah");

while ($sb = $db->fetch_assoc($query)){

   //count the number of times the comment's id appears in other comment's my_parent field. Also echo the information back.

   if($sb['replies']>0){
      //add some padding to the next recursion

      echo '<div style="padding-left:8px;">';
      comment_list($newid);
      echo '</div>';

   }

}//end loop

}//end function

comment_list(1);

I hope that makes some sense.

rodents

Custom .htaccess isn't really needed... since you can just link to the php file with no browser problems.

I just added style="display:block;" to the image and object tags, and it works fine. I don't think that I would want to put img {display:block;} in the stylesheet because that would mean that with all the other pages I do that contain images I'd need to enclose it in a special tag.

Coloring the tables bgcolor yellow shows that it's the tables fault. I was using DIVs, but found later that the table behaved better. The divs still had the gap.

Closed the img tags and changed the attribute as instructed.

Tobi, you're brilliant!!! Fabulous solution. Will it cause any load increase?