<?php
$username="root";
$password="";
$database="amx";

mysql_connect("localhost",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM rank WHERE skill > 1 ORDER BY skill DESC";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>

<?php
$i=0;
while ($i < $num) {
$auth=mysql_result($result,$i,"auth");
$ip=mysql_result($result,$i,"ip");
$f1=mysql_result($result,$i,"name");
$f2=mysql_result($result,$i,"kills");
$f3=mysql_result($result,$i,"deaths");
$f4=mysql_result($result,$i,"headshots");
$f5=mysql_result($result,$i,"skill");
$f6=mysql_result($result,$i,"points");
/*$steam=mysql_result($result,$i,"steam");*/
$country=mysql_result($result,$i,"country");
if($i+1==1) $class="red";
if($i+1==2) $class="blue";
if($i+1==3) $class="green";
if($i+1>3) $class="default";


$salis = strtolower($country);

?>

<!--<?php
if($steam==1)
echo "<img src=\"img/SLOT.png\" alt=\"Slot\" title=\"Slot\" width=\"15\" height=\"15\" />";
elseif($steam==2)
echo "<img src=\"img/ADMIN.png\" alt=\"Administrator\" title=\"Administrator\" width=\"15\" height=\"15\" />";
else
echo "<img src=\"img/blank.png\" alt=\"Player\" title=\"Player\" width=\"15\" height=\"15\" />"; ?></td>-->
<td class="default" width="200">
<img src="<?php echo "flags/$salis.png"?>" alt="<?php echo "$country flag"?>"/> <span title="<?php echo $ip ." | ". $auth; ?>"><?php echo $f1; ?></span></td>
<td class="sth2"><?php echo $f2; ?></td>
<td class="sth2"><?php echo $f3; ?></td>
<td class="sth2"><?php echo $f4; ?></td>
<td class="sth2"><?php echo $f5; ?></td>
<td class="sth2"><?php echo $f6; ?></td>
</tr>
<?php
$i++;
}
?>