[RESOLVED] Determining High Scores From DB

[system_critical]

Hi,

I've got a score field in my database to store people's high scores in the game I've built. What would be the best way to list these scores in descending order or from a specific point, say the current user's score? I wasn't sure how to go about this in PHP or if there was a SQL statement for sorting numerical terms. Thanks.

[laserlight]

You can ORDER BY score DESC. If you want to begin listing those scores below the user's score, then you also need to specify WHERE score<$score, with $score being the user's score (or perform a join or subquery if you only have the user's id).

[system_critical]

Thanks, I figured there was some SQL that could handle it. I'll hit up the SQL manual.