Foreach loop nested in a while loop

[ironikart]

I've been having a little trouble with a foreach code. I've tried using some principles I thought I had learned in a previous thread, but when I use the foreach loop it only loops once, when it should loop through the entire array (should return 3 times with the 3 rows its pulling from the sql database).

Is this a problem caused by nesting the foreach loop inside the while loop?

while($forums[] = mysql_fetch_array($forums_result))//feed sql data into array

while ($groups = mysql_fetch_array($groups_result)) {

echo "<tr><td colspan=\"5\" class=\"heading\"><img src=\"images/spacer.gif\" 
	  width=\"15\" height=\"1\">".$group['group_name']."</td></tr>";

foreach ($forums as $forum) {
	if ($forum['group_id'] == $group['group_id']) 
	{
	echo "<tr align=\"left\" valign=\"top\">";
    echo "<td align=\"center\" valign=\"middle\" bgcolor=\"#4F5249\"><img src=\"images/icon_sticky_darkgreen.gif\" width=\"23\" height=\"20\"></td>";
    echo "<td bgcolor=\"#4F5249\"><a href=\"#\">".$forum['forum_name']."</a><br>";
    echo "this is the forum description</td>";
    echo "<td align=\"center\" bgcolor=\"#4F5249\">1203</td>";
    echo "<td align=\"center\" bgcolor=\"#4F5249\">4032</td>";
    echo "<td bgcolor=\"#4F5249\">&nbsp;</td>";
    echo "</tr>";
	}
}
}

[ironikart]

I can't explain it. I re-wrote the code, I ended up changing it to be identical to the code above, with the braces in a slightly different place and it works?
should:

while ($value1 = $value2) {
....
}

be any different to:

while ($value1 = $value2)
{
....
}

[cgraz]

No, spacing doesn't matter. I'm wondering if $group is defined. You have $groups set as the variable to fetch the array from the database, but I don't see you using $groups, you use $group in your first post.

Cgraz

[ironikart]

thanks for that. I don't know how many times a read that code and didn't notice about the groups/group naming thing. I deserve a trout slap for that one!