Output Order Mystery

jfeather

Problem:
I am outputing a mySQL table to a HTML table. I am using an "order by" in my SQL statement but there is a problem. The records are being outputed in order EXCEPT all the records with images are being outputed at the end of the table not in order where they should be. This one has me completely bamboozeld!! NFI what's going on. Any help appreciated.
Kind Regards
John F.

Anon

Could we see your query?

jfeather

Sorry Should have been more informative. Here is the Query:

<table>
<?
mysql_connect("", UN,PW)
or die("Couldn't make connection.");

$query = "select * from species order by Species";
$result = mysql_db_query("db", $query);
while ($r=mysql_fetch_array($result))
{
$ID = $r["ID"];
$Species = $r["Species"];
$MinWt = $r["MinWt"];

$Bonus = $r["Bonus"];

echo "
<tr>
<td><a href=\"edit_species.php?ID=$ID\">$ID</a></td>
<td>$Species</td>
<td>$MinWt</td>
<td>$Bonus</td>
<td><img src=getphoto.php?ID=$ID></td>
</tr>";
}
?>
</table>