kaos
August 2nd, 2010, 19:36
ok i want all the sub forums of my forum to show under the category name but they show 1 on each thingy view here Only the registered members can see the link. but first go to Only the registered members can see the link. and the login is
username :: test
password :: test
The code is as follows
<?php
while($rows2=mysql_fetch_array($result2)){ // Start looping table row
$sql="SELECT * FROM forum_categorys WHERE ffname = '{$rows2['fname']}' ORDER BY id DESC";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
?>
<table width="90%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC" class="maintable">
<tr>
<tr><td><?php echo $rows2['fname']; ?></td></tr>
<td width="20%" align="center" bgcolor="#E6E6E6"><strong>Category</strong></td>
<td width="10%" align="center" bgcolor="#E6E6E6"><strong>Topics</strong></td>
<td width="20%" align="center" bgcolor="#E6E6E6"><strong>Replies</strong></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left"><a href="view_cat.php?id=<?php echo $rows['id']; ?>"><?php echo $rows['catname']; ?></a></td>
<td align="center" bgcolor="#FFFFFF"><?php echo $rows['topics']; ?></td>
<td align="center" bgcolor="#FFFFFF"><?php echo $rows['replys']; ?></td>
<?php
}}
?>
</tr>
</table>
I dont see what is wrong :s
username :: test
password :: test
The code is as follows
<?php
while($rows2=mysql_fetch_array($result2)){ // Start looping table row
$sql="SELECT * FROM forum_categorys WHERE ffname = '{$rows2['fname']}' ORDER BY id DESC";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
?>
<table width="90%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC" class="maintable">
<tr>
<tr><td><?php echo $rows2['fname']; ?></td></tr>
<td width="20%" align="center" bgcolor="#E6E6E6"><strong>Category</strong></td>
<td width="10%" align="center" bgcolor="#E6E6E6"><strong>Topics</strong></td>
<td width="20%" align="center" bgcolor="#E6E6E6"><strong>Replies</strong></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left"><a href="view_cat.php?id=<?php echo $rows['id']; ?>"><?php echo $rows['catname']; ?></a></td>
<td align="center" bgcolor="#FFFFFF"><?php echo $rows['topics']; ?></td>
<td align="center" bgcolor="#FFFFFF"><?php echo $rows['replys']; ?></td>
<?php
}}
?>
</tr>
</table>
I dont see what is wrong :s