Highscores system, first at top [database]

[beennn]

I've set up highscores for a game i'm working on, though im faced with an issue when two people get the same score. I want the player who achieved the score first to be at the top of the leader boards. Does anyone have any suggestions on how I can achieve this? Any help or pointers would be great, and sorry if this isn't the correct place to be asking.

Edited November 17, 2012 by beennn

[Ingolme]

I think in SQL it would be something like this: SELECT * FROM high_scores ORDER BY score DESC, date (Supposing the date of the high score was stored in the table)

[thescientist]

As Ingolme alluded to, you would want to save the time that user set the high score. The most flexible way to save dates is as a timestamp.http://php.net/manual/en/datetime.gettimestamp.php From this point onward, you can ORDER BY in the query against the name of the column that you saved the timestamp in, or ORDER BY the high score, and if you have a tie, the user with the "smaller" timestamp would be listed first.

[beennn]

Thank you both very much.