I want to know the position of a entry in a highscore table but the only way i can think of doing this is "SELECT * from entries ORDER BY score DESC" and then loop though all the entries in php until i find the record i want.

It seems like there ought to be a better way to do this especially as the number of records increases. Can you find this position information directly in the SQL or is there a php function that will be better than going through all the records?