`username`,`gamename`,`score`
To get the highscores for each of the games, I run this query:
Code: Select all
SELECT `username`,`gamename`,MAX(score) FROM `arcade_highscores` GROUP BY `gamename`Moderator: General Moderators
Code: Select all
SELECT `username`,`gamename`,MAX(score) FROM `arcade_highscores` GROUP BY `gamename`Code: Select all
SELECT `ah`.`username`,`ah`.`gamename`,`ah`.`score` FROM (
SELECT MAX(`score`) AS maxscore
FROM `arcade_highscores`
GROUP BY `gamename`
) AS scores
INNER JOIN `arcade_highscores` AS `ah` ON `ah`.`score` = scores.maxscore