Versuchs mal so:
PHP-Code:
$wingamer = $db->query("
select
score.gameid, score.game, score.userid, score.username, score.score
from
bb".$n."_arcade score,
(select gameid, max(score)max_score from bb".$n."_arcade group by gameid ) max_scores
where
score.gameid=max_scores.gameid
and score.score = max_scores.max_score
order by
score.date,
score.time
");
Geht aber erst ab MySQL >=4.1