Numbered list

[Anon]

I've imputted information to a database and now I'm displaying that information in a table on a website.
What I'd like to do is have the script number the entries based by score. While I can make it order them by score I don't know how to make it give the same number to entries that are "tied" for points.

IE.
1. Jeff - 10 points
2. Dave - 9 points
3. Carl - 9 Points

I want it to display like this:
1. Jeff - 10 points
2. Dave - 9 points
2. Carl - 9 Points

Cany help?

[Anon]

$result = mysql_query("SELECT * FROM players ORDER BY score DESC",$C);

$max = 1; //Maximum position on table
for($i=0;$i<mysql_num_rows($result);$i++){

//First player, maximum score
if($i == 0){
echo $max."-->".mysql_result($result,$i,"player")." score:".mysql_result($result,$i,"score"),"<BR>";
}else{

//Rest of players. If the score of the actual is less that the score of the one before him, add +1 to max.
if(mysql_result($result,$i,"score") < (mysql_result($result,($i-1),"score"){
$max++;
}

//Table
echo $max."-->".mysql_result($result,$i,"player")." score:".mysql_result($result,$i,"score")."<BR>";

}

You'll have to change the fields of mysql_result and mysql_query to the adequate ones.

Hope this helps

fLIPIS