MySQL Forums :: PHP :: Get row of a specific result

Advanced Search

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

Subject Written By Posted
Get row of a specific result dfgdfg sddsfgfsdf 12/22/2013 12:37AM
Re: Get row of a specific result Rick James 12/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.