Get row of a specific result

[dfgdfg sddsfgfsdf]

I'm working on some kind of highscore ranking system, which is supposed to display your current rank in your profile.
However, as ranks might change every few seconds, I have no idea how to get the rank of a specific user.
Do I have to calculate all ranks again every few seconds and save them?

I was thinking of sorting it by highscore and somehow get the row of the resulting query.

My table is very simple (name, highscore, date).



Edited 1 time(s). Last edit at 12/22/2013 12:38AM by dfgdfg sddsfgfsdf.