Mini forums - not showing all...

Copernicus

Not sure why but my small forum I made isn't showing all the forums within each category. Why? I'm not sure, if anyone can find something wrong, then please tell me. I commented it as much as I could...

<?php
session_start();
?>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
      <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<style type="text/css">
<!--
.catbg {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: x-small;
	font-style: normal;
	line-height: 24px;
	font-weight: normal;
	font-variant: normal;
	text-transform: none;
	color: #FFFFFF;
	background-image: url(cat.jpg);
	background-repeat: no-repeat;
	background-position: center top;
	width: 650px;

}

.forumstats {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: x-small;
	font-style: normal;
	line-height: 24px;
	font-weight: normal;
	font-variant: normal;
	text-transform: none;
	color: #FFFFFF;
	background-image: url(forumstats.jpg);
	background-repeat: no-repeat;
	background-position: center top;
	width: 650px;

}
-->
</style>

</head>
<center>
<?php

/* ***** INCLUDE NECESSARY FILES ***** */
include('inc/connect.php');
include('inc/config.php');
include('forumstats.php');

$username = $_SESSION['username'];

/* ***** SELECT ALL CATEGORIES AND DEFINE THEIR TITLES ***** */
$query = "SELECT * FROM categories ORDER BY id ASC";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{
$cat_name = $row['title'];

?>
<br><div class="catbg">>> <?php echo "$cat_name"; ?></div>
<?php
/* ***** SHOW WHAT EACH COLUMN MEANS WITH BORDERLESS TABLE ***** */
   echo "<table width=\"650\" cellpadding=\"0\" border=\"0\">
  <tr>
    <td width=\"50\">&nbsp;</td>
    <td width=\"207\">Forum</td>
    <td width=\"229\">Latest Thread</td>
    <td width=\"66\">Threads</td>
    <td width=\"64\">Posts</td>
  </tr>
</table>";

/* ***** SELECT ALL FORUMS WITHIN THAT CATEGORY ***** */
$result2 = mysql_query("SELECT * FROM forums WHERE cat_name = '$cat_name'");

 while($row2 = mysql_fetch_array($result2))
 {

    $forum_id = $row2['id'];
    $forum_title = $row2['title'];
    $forum_description = $row2['description'];


/* ***** START OF QUERY FOR THREAD COUNT ***** */ 
 $result3 = mysql_query("SELECT * FROM topics WHERE fid = '$forum_id'");
 $nr3 = mysql_num_rows($result3) or die(mysql_error());

/* ***** END OF THREAD COUNT SNIPPET ***** */ 

/* ***** START OF QUERY FOR LATEST THREAD ***** */ 
 $result4 = mysql_query("SELECT * FROM topics WHERE fid = '$forum_id' ORDER BY id DESC limit 0,1");
 $x = mysql_fetch_array($result4);

 $latest_id = $x['id'];
 $latest_title = $x['title'];
 $latest_poster = $x['poster'];

/* ***** END OF LATEST THREAD SNIPPET ***** */

echo "
<table width=\"650\" height=\"57\" border=\"1\">
  <tr>
    <td width=\"50\" height=\"61\"><center>New!</center></td>
    <td width=\"207\"><A href=\"viewforum.php?fid=$forum_id\">$forum_title</a><br>
    <i>$forum_description</i></td>
    <td width=\"229\"><a href=\"viewthread.php?id=$latest_id\">$latest_title</a>
	<Br>
	by <a href=\"viewprofile.php?u=$latest_poster\">$latest_poster</a></td>
    <td width=\"66\"><center>$nr3</center></td>
    <td width=\"64\">&nbsp;</td>
  </tr>
</table>";

/* ***** END BOTH WHILE STATEMENTS ***** */
}
}

?>

halojoy

isn't showing all the forums within each category

do you get blank page?
do you get anything at all?
is there any Warning Error or Notice from PHP?

sorry, but your description of problem
is way too little

We dont like playing guessing game,
and NO, I am sorry again:
Noone will bother to copy paste and save your code
to run it and see what's wrong ....
it wouldnt work anyway, as we dont have your database tables

To begin with, put PHP in DEBUG Mode in your script:

<?php
// these should be first lines in your page
error_reporting(2047); PHP DEBUG Mode!!!!!
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
      <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">