<?php
$mysqli = new mysqli("localhost", "root", "", "clans");
$query = $mysqli->query("SELECT * FROM sc_players ORDER BY `civilian_kills` DESC");
while ($row = $query->fetch_array())
{
echo $row['tag'] . " | " . $row['name'] . " | " . $row['civilian_kills'] . "<br>";
}
Resultado:
tst | Mcjunior2 | 6
pira | lucaslemos | 3
tst | lucaslemos2 | 3
pira | Mcjunior | 2