hi, can you help me? :P
I installed this script in my site, and it works pretty well but it will only have 1 parent forum...
when I create another nothing changes, even if I create foruns inside it...
and the parents and foruns are being inserted in the database, so I guess it's a problem of showing and not of inserting...
here's the code where it's supposed to show all parents
PHP Code:
$table = $table."
<table width='95%' border='1' align='center' cellpadding='3' cellspacing='1' class='forum'>";
$query = "SELECT * FROM parent_forum ORDER BY pid ASC";
$result = mysql_query($query);
$num3 = mysql_numrows($result);
//Loop out code
$i=0;
while ($i < $num3) {
$pid=@mysql_result($result,$i,"pid");
$ptopic=@mysql_result($result,$i,"topic");
$ptopic = stripslashes($ptopic);
$table = $table."
<tr>
<td width='100%' class='forum'><img src='images/iconforum.png'> <b>".$ptopic."</b></td>
</tr>
</table>
<table width='95%' border='1' align='center' cellpadding='3' cellspacing='1' class='forum'>
<tr>
<td width='55%' class='forum2' align='center'><strong>Fórum</strong></td>
<td width='10%' class='forum2' align='center'><strong>Tópicos</strong></td>
<td width='10%' class='forum2' align='center'><strong>Posts</strong></td>
<td width='20%' class='forum2' align='center'><strong>Último Post</strong></td>
</tr>";
$query = "SELECT * FROM forum Where pid='".$pid."'";
$result = mysql_query($query);
$num2 = mysql_numrows($result);
$i=0;
while ($i < $num2) {
$fid=@mysql_result($result,$i,"fid");
$topic=@mysql_result($result,$i,"topic");
$desc=@mysql_result($result,$i,"desc");
$posts=@mysql_result($result,$i,"posts");
$threads=@mysql_result($result,$i,"threads");
$lby=@mysql_result($result,$i,"lby");
$ldatetime=@mysql_result($result,$i,"ldatetime");
$ltopic=@mysql_result($result,$i,"ltopic");
$lid=@mysql_result($result,$i,"lid");
$topic = stripslashes($topic);
$ltopic = stripslashes($ltopic);
$desc = stripslashes($desc);
if($ltopic == ""){
$lpost = "<i>Nunca</i>";
}
else{
$lpost = "<a href='view_topic.php?id=".$lid."'>".$ltopic."</a> por: <a href='perfil.php?user=".$lby."'>".$lby."</a><br>".$ldatetime;
}
$table = $table."
<tr>
<td class='trow'><a href='main_forum.php?fid=".$fid."'>".$topic."</a><BR><i>".$desc."</i></td>
<td align='center' class='trow'>".$threads."</td>
<td align='center' class='trow'>".$posts."</td>
<td align='center' class='trow'>".$lpost."</td>
</tr>";
$i++;
}
$i++;
}
$table = $table."
</table><br>";
and here's the link http://www.maplepet.co.cc/main_forum2.php
ty from now. :D