hi everyone, 

I' ve a table named as 'highscores', inserting result scores of a game and 
players name(each player can only play once)  what I want to do is to get the 
"current rank" of a player over a listing of all rows ordered by scores desc. 

id -name - score 
1 - userA - 8
2 - userB - 3
3 - userC - 10
4 - userD - 2
5 - userE - 7

here is how I figured out this thing:

$sql=mysql_query(SELECT userD  FROM highscores ORDER BY score DESC);
           echo "your rank is:  $i ";

how can I get a specific row's  "formatted no"  through all affected rows? Is 
there a MySQL command doing this job that i am unaware of? 

thx  in adv. 

Reply via email to