Existing Forums not Found by MySQL query

[misseyB]

Hi there

I'm in the process of setting up a discussion forum and unfortunately when i the following MySQL query is executed it returns he message 'No Forums' and yet i have created two forums with the same cat_id as one of the categories.

The code is as follows;

$forumsql = "SELECT * FROM forums WHERE cat_id = " . $catrow['id'] . ";";
$forumresult = mysql_query($forumsql);
if($forumnumrows ==0) {
echo "<tr><td>No forums!</td></tr>";

All the tables are InnoDB so they should be referencing each other but I'm just wondering whether i have linked them properly.

Any ideas would be most welcome

[maxpup979]

print out the query to verify that you are passing the proper cat_id into the query.
also, I am not seeing where you are declaring $forumnumrows. I assume you simply left out the line :

$forumnumrows=mysql_num_rows($forumresult);

Hope that helps!

[misseyB]

Hi
Thank you so much for replying. This might be a really stupid question but how do i print out the query?

I'm actually using code from a 'book about PHP so i'm not entirely sure i'm not entirely certain if it's declaring $forumnumrows or not (still quite a novice in that department). The entire code is as follows;

<?php
require("header.php");
$catsql = "SELECT FROM categories;";
$catresult = mysql_query($catsql);
echo "<table cellspacing=0>";
while($catrow = mysql_fetch_assoc($catresult)) {
echo "<tr class='head'><td colspan=2>";
echo "<strong>" . $catrow['name'] . "</strong></td>";
echo "<tr>";
$forumsql = "SELECT FROM forums WHERE categories_id = " . $catrow['id'] . ";";
$forumresult = mysql_query($forumsql);
if($forumnumrows ==0) {
echo "<tr><td>No forums!</td></tr>";
}
else {
while($forumrow = mysql_fetch_assoc($forumresult)) {
echo "<tr>";
echo "<td>";
echo "<strong><a
href='viewforum.php?id="
. $forumrow['id'] . "'>" .
$forumrow['name'] . "</a></strong>";
echo "<br/><i>" . $forumrow['description'] . "</i>";
echo "</td>";
echo "</tr>";
}
}
}
echo "</table>";
require("footer.php");
?>

Thanks again for your help

[maxpup979]

I added the lines in the code.

<?php
require("header.php");
$catsql = "SELECT * FROM categories;";
$catresult = mysql_query($catsql);
echo "<table cellspacing=0>";
while($catrow = mysql_fetch_assoc($catresult)) {
echo "<tr class='head'><td colspan=2>";
echo "<strong>" . $catrow['name'] . "</strong></td>";
echo "<tr>";
$forumsql = "SELECT * FROM forums WHERE categories_id = " . $catrow['id'] . ";";
//The next line was added by maxpup979
echo $forumsql;
$forumresult = mysql_query($forumsql);
//The next line was added by maxpup979
$forumnumrows=mysql_num_rows($forumresult); 
if($forumnumrows ==0) {
echo "<tr><td>No forums!</td></tr>";
}
else {
while($forumrow = mysql_fetch_assoc($forumresult)) {
echo "<tr>";
echo "<td>";
echo "<strong><a
href='viewforum.php?id="
. $forumrow['id'] . "'>" .
$forumrow['name'] . "</a></strong>";
echo "<br/><i>" . $forumrow['description'] . "</i>";
echo "</td>";
echo "</tr>";
}
}
}
echo "</table>";
require("footer.php");
?>