mysql_fetch_assoc only returns 1 result
<p>mysql_fetch_assoc is only fetching one record (checked database side of things all good)
Php Code:</p>

<pre><code>&lt;?php 
$folder_id = $_GET['folder_id'];
$query = mysql_query("SELECT * FROM gallery_photos WHERE folder_id = $folder_id");

if (mysql_num_rows($query) == 0)
{
echo '&lt;h2&gt;Sorry, you cannot change a folders photo cover if that folder has no    photos in it&lt;br /&gt; &lt;a href="gallery.albums.php?fder_id='.$folder_id.'"&gt;Back to the folder&lt;/a&gt;&lt;h2&gt;';
}
else
{

while ($row = mysql_fetch_assoc($query))
{
    echo '&lt;img src="gallery_photos/'.$row['photo_name'].'" width="200"';
}
}
?&gt;
</code></pre>

<p>Can you help?</p>
