multi-threading

phlow

i know that this is a very faq, but i couldn't find a satisfying answer.

i need a hint, how to build a phpbuilder-style forum (with these "+" and "-" icons, the multi-threading feature). of cours i've tried to find a solution in the sourcecode of other forums, but firstly i've not found a forum similar to the phpbuilder one and secondly i was confused by complexity of the files.

any hints are welcomed, thanx...Phlow

mikesgt2

If you want to download one try phorum (http://phorum.org/). This forum uses phorum or somthing very similar.

If you want to build your own check out these pages:

http://www.thescripts.com/serversidescripting/php/tutorials/discussionforumswithphp/page0.html
http://www.learnground.com/learning_php_forum_1.php

Basically you need to store the id of the message you are replying to in each reply (did u get that?).

phlow

thanx, i think my database design is right (id, id_of_author, id_of_parent, date, header, content), but i have problems with the recorsive function. u know, this "select first thread then check if there are sub-threads...".

any tips?
thanx, Phlow.

mikesgt2

Just get the thread and use the id of that thread to select more threads. You might want to use somthing like this.

<?php
function printThread($id,$replyto=0)
{
$result = mysql_query("SELECT * FROM threads WHERE threadid=$id && replyto=$replyto");
if(mysql_num_rows($result))
{
while($row = mysql_fetch_array($result))
{
// this loop makes it indent
for($i=0;$i<=$replyto;$i++)
print "  ";
// prints the subject
print "$row[subject]<br>";
// this bit runs this function again
printThread($id,($replyto+1));
}
}
}
?>

Somthing like that, I havn't tested it at all.

phlow

sorry that i have to bother you again, but the function won't work. i modified it like that:

function thread($id,$replyto=0)
{
$result = mysql_query("SELECT * FROM threads WHERE id=$id && parent_id=$replyto");

echo mysql_error();

if(mysql_num_rows($result))
{
while($myrow = mysql_fetch_array($result))
{
// this loop makes it indent
for($i=0;$i<=$replyto;$i++)

			print " "; 
			// prints the subject 
			printf ("+ %s id:%s | replyto:%s<br>\n", $myrow["header"], $id, $replyto);
			// this bit runs this function again
			thread($id,($replyto+1)); 

	}
}

}

and i run it with "thread(1)", but the only thing it does is to print out only the message with the id 1. any idea?

thanx, Phlow.

mikesgt2

send me a database dump of the data you have and I can try it out. Use the email thing on thsi forum.

Mike