<?php

$server = "127.0.0.1";
$username = "root";
$password = "";
$db = "blackops";
mysql_connect($server, $username, $password);
mysql_select2_db($db);
$result = mysql_query("SELECT KILLS, NAME FROM player_data ORDER BY KILLS LIMIT 20");
$id = 0;

echo "
<table>
<tr>
<td>Position</td>
<td>Name</td>
<td>Kills</td>
</tr>
";

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    $name = $row['KILLS'];
    $kills = $row['NAME'];
    echo "
    <tr>
    <td>$id</td>
    <td>$name</td>
    <td>$kills</td>
    </tr>
    ";
    $id ++;
}
echo "</table>";
mysql_close();
?>