<?php
$database = new PDO("sqlite:stats.sqlite");
$sql = "SELECT * FROM bodystats ORDER BY HeAD DESC LIMIT 10";
$t = 1;
echo "<table class=\"center\"><tr><td>#</td><td>Nickname</td><td>Kills</td></tr>
";
foreach ($database->query($sql) as $row)
{
echo "<tr><td>".$t."</td><td><a href=\"player.php?nick=".$row['nick']."\">".$row['nick']."</a></td><td>".$row['HeAD']."</td></tr>";
$t++;
}
echo "</table>";
?>