[SOLVED] Only displaying 1 row

[Ryuujin]

I have this code to show my forum categories:

function Template_Main_Categories()
{
global $db_prefix;
// Show the forum categories
$result = mysql_query("SELECT * FROM " .$db_prefix. "categories ORDER BY cat_order");
while($row = mysql_fetch_array( $result ))
{
	$cat_id = $row['id'];
	echo '<div class="Forum_Categories">
			<table border="1" width="100%">
				<tr>
					<th colspan="4" class="Table_Header">', $row['cat_name'], '</th>
				</tr>
				<tr>
					<th>Board</th><th>Topics</th><th>Posts</th><th>Last Post</th>
				</tr>';
	$result = mysql_query("SELECT * FROM " .$db_prefix. "forums WHERE cat_parent='$cat_id' ORDER BY forum_order");
	while($row = mysql_fetch_array( $result ))
	{
	echo		'<tr>
					<td>', $row['forum_name'], '</td><td></td><td></td><td></td>
				</tr>';
	}
	echo	'</table>
			<br />
		</div>';
}
}

The database has 2 categories and 2 forums. 1 forum for each category, but it is only printing out 1 category. Any ideas?

[maxudaskin]

Put in echo mysql_num_rows($result); then post what it says.

[Ryuujin]

For categories it echoed 2, for forums it echoed 1 :\

[PFMaBiSmAd]

You have two nested queries that are both using $result. Pick unique variable names please.