<?php
$servername = "";
$username = "";
$password = "";
$dbname = "";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT Name, Level FROM Character order by Level desc limit 10";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $x = 0;
    // output data of each row
    while($row = $result->fetch_assoc()) {

        $x = $x + 1;
        echo "
                <tr>
            <td>".
           $x."
 </td>
            <td>".

             $row['Name']."
            </td>
            <td>

            ".$row['Level']."
            </td>

        </tr>
        ";

    }
} else {

}
$conn->close();

?>