Not ordering by date?

[Bolanb]

I have a feature that shows the most recently replied to posts of each forum on my website, except in some forums the person who has replied the latest remains on the bottom instead of being aligned at the top, and in other forums it works perfectly (aligned on the top). What could be causing such a contradiction? My coding for retrieving the data is:

 

<?php

$faces="SELECT * FROM ffaces WHERE fid='$fid1' ORDER BY date ASC";
$fresult=mysql_query($faces);

$color="1";

while($rowface=@mysql_fetch_array($fresult)){

if($color==1){
echo "<tr bgcolor=#000030>
<td vlign=middle>
<font face=arial size=2><u><a href='".$rowface['link']."'>
".$rowface['user']."</u></a></td></tr>";
$color="2";
}
else
{
echo "<tr bgcolor=#000050>
<td vlign=middle>
<font face=arial size=2><u><a href='".$rowface['link']."'>
".$rowface['user']."</u></a></td></tr>";
$color="1";
}
}
?>

 

Thanks.

[fenway]

Post the table structure as is required by the stickies.