MySQL Forums
Forum List  »  PHP

Get row of a specific result
Posted by: dfgdfg sddsfgfsdf
Date: December 22, 2013 12:37AM

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.

Options: ReplyQuote

Written By
Get row of a specific result
December 22, 2013 12:37AM
December 23, 2013 05:01PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.