显示前10名球员姓名及其硬币

Question

I was assigned a task to make a leader board

I was making it and i got stuck at making it display more then one person.

$SQL = $odb -> query("SELECT username,SUM(kills) AS `kills`
                      FROM `players`
                      GROUP BY username
                      ORDER BY `kills` DESC
                      LIMIT 10");
                  $SQL -> execute();
                  echo $SQL -> fetchColumn(0);
                  echo '  ';
                  echo $SQL -> fetchColumn(1);

and that just make's it display 1 players name then their coins. I need it to display 10 in order from greatest coins to least.

Answer 1

According to the PHP Documentation you can do the following if you use PDO :

$sql = "SELECT username,SUM(kills) ASkills
                      FROMplayers
                      GROUP BY username
                      ORDER BYkillsDESC
                      LIMIT 10"
foreach ($odb->query($sql) as $row) {
        echo $row['username'].$row['kills'];
    }

You were just missing a loop there.