[Castel]

Originally posted by john.eovie
Ok, when I run

$leaderboard_q = $DB_site->query("SELECT game,userid,comment,date,max(score) as maxscore
                                    FROM arcade
                                    WHERE game='$gamename'
                                    GROUP BY userid
                                    ORDER BY maxscore DESC
                                    LIMIT $top_number");

in place of the standard leaderboard_q code, I get no records returned.

John I ran that query in PHPadmin and it works perfect. I used order by userid and no limit to check (after a checked there was multiple record for the same user) and the query returned only the highest score for each user. I think this is the ticket to your arcade hack with dual display mode, I had doctored up another way after out conversation earlier but this is much better.