Top 10 PK

[Swarlog]

Código [Seleccionar] Expandir

<table width="250px;">
<?php
    $connection = mysql_connect("SERVER IP", "MYSQL USER", "MYSQL PASSWORD") or die("Connection isn't available!");
    mysql_select_db("MYSQL DB", $connection) or die("Database isn't available!");
    
    
    $q = mysql_query("SELECT * FROM characters WHERE pkkills > 0 AND accesslevel = 0 ORDER BY pkkills DESC LIMIT 10");
    $i = 1;
    if ($q) {
        while ($char = mysql_fetch_array($q))
        {
            echo "<tr>";
            echo "<td style='width:11px;color:#000;'>" . $i . ".</td>";
            echo "<td style='width:20px;color:#000;'>" . $char['char_name'] . "</td>";
            echo "<td style='width:20px;text-align:right;padding-left:22px;color:#000;'>" . $char['pkkills'] . "</td>";
            echo "</tr>";
            $i++;
        }
    }
?>