Getting the Order Number Quickly?

[TEENFRONT]

Hey

 

Il jump straight in... im selecting a list of website members ordered by how mnay games they have all played..

 

When a user logs in, i want to quickly show them their overall ranking out of all members. Now the only way i know how to do this so far is to

 

SELECT * FROM members ORDER BY games_played DESC

 

then loop through, adding 1 till i i find a match of the logged in username to the results username.. this is horrible. lol.

 

Can i quickly ask mysql to do say something like this?

 

SELECT * FROM members WHERE username=$username ORDER BY games_played DESC

 

But get it to tell me what position (row number?) it found the matching result on? So it dont have to loop through everything till i find a match...

 

Many thanks!

 

[corbin]

SELECT COUNT(*) FROM members WHEER games_played > $games_played;

 

 

Where games_played is the number of games played by the user about whom you want to know.