<?php
include('config.php');
$top = '10'; //Top Number
mysql_connect($host, $user, $pass);
mysql_select_db($db);
echo "
<div class='bar'><div class='place'>#</div><div class='player'>NAME</div><div class='count'>PVP</div></div>
";
$i = 1;
$sql = "SELECT char_name, pvpkills FROM characters WHERE accesslevel=0 ORDER BY pvpkills DESC LIMIT $top";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query))
{
echo
"
<div class='bar'>
<div class='place'>".$i++."</div>
<div class='player'>".$row['char_name']."</div>
<div class='count'>".$row['pvpkills']."</div>
</div>
";
}
echo "
";
?>