[Ryangel]

These are the 4 queries that i use atm that works in showthread.php

PHP Code:

$tetrisleaderboard = $DB_site->query_first('SELECT userid FROM arcade WHERE game = "tetris" ORDER BY score DESC LIMIT 1');
$tetriskingid = $tetrisleaderboard['userid'];
$pacmanleaderboard = $DB_site->query_first('SELECT userid FROM arcade WHERE game = "pacman" ORDER BY score DESC LIMIT 1');
$pacmankingid = $pacmanleaderboard['userid'];
$spaceinvadersleaderboard = $DB_site->query_first('SELECT userid FROM arcade WHERE game = "spaceinvaders" ORDER BY score DESC LIMIT 1');
$spaceinvaderskingid = $spaceinvadersleaderboard['userid'];
$snakeleaderboard = $DB_site->query_first('SELECT userid FROM arcade WHERE game = "snake" ORDER BY score DESC LIMIT 1');
$snakekingid = $snakeleaderboard['userid']; 


though .... it'll be great if one query is posible... I have tried:

PHP Code:

$leaderboard_query = $DB_site->query("SELECT game,userid, MAX(score) as score FROM arcade GROUP BY game ORDER BY score DESC");
while($leaderboard = $DB_site->fetch_array($leaderboard_query)){
    if($leaderboard['game']=="tetris")
        $tetriskingid = $leaderboard['userid'];
    if($leaderboard['game']=="pacman")
        $pacmankingid = $leaderboard['userid'];
    if($leaderboard['game']=="spaceinvaders")
        $spaceinvaderskingid = $leaderboard['userid'];
    if($leaderboard['game']=="snake")
        $snakeinvaderskingid = $leaderboard['userid'];
} 


but this doesnt pull the userid and the max(score) to the same row... argh.