[RESOLVED] even easier loop question - stops after only one row

[laurus]

I can't seem to loop through 7 rows of data returned from a simple query.
It works fine for the first row, then stops.

$query = "SELECT * FROM stores";
$result2 = mysql_query($query) or die('Query failed: ' . mysql_error());;

$num_rows = mysql_num_rows($result2);
echo "$num_rows Rows\n<br />";

$row3 = mysql_fetch_assoc ($result2);

foreach($row3 as $key => $value)
{
echo "Key: $key; Value: $value<br />\n";
}

[ClarkF1]

$query = "SELECT * FROM stores";
$result2 = mysql_query($query) or die('Query failed: ' . mysql_error());;

$num_rows = mysql_num_rows($result2);
echo "$num_rows Rows\n<br />";

while ($row3 = mysql_fetch_assoc ($result2))
{
foreach($row3 as $key => $value)
{
echo "Key: $key; Value: $value<br />\n";
}
}

[laurus]

That works .