I'm trying to enumerate this row, the users names, according to the points row, in numeric order, i.e., highest to lowest, the highest being listed first and the lowest being listed last... could anyone show me what I should do to accomplish that... thanks
Code: Select all
$them=@mysql_query("select username from users") or die(mysql_error());
while($row = mysql_fetch_array($them))
{
echo "
<div style='border:#EFEFEF 1px solid;width:200;background:#FFFFFF;'>
<img src='http://blah.com/blah.gif'>
<a href='mypage.php' style='text-decoration:none'>
<font color=black>".$row['username']."</font></a>
</div>";
}