$q = mysql_query("SELECT @:=@+1 rank, user FROM (SELECT @:=0) r, u ORDER BY score DESC LIMIT 5"); while($arr = mysql_fetch_array($q)) { echo '#'.$arr['rank'].' '.$arr['user'].'
'; }