<?php
    header('Content-Type: text/html; charset=utf-8');

    $servername = "localhost";
    $username = "seulogin";
    $password = "suasenha";
    $dbname = "nomedobanco";

    $mysqli = new mysqli($servername, $username, $password, $dbname);
    $mysqli->set_charset("utf8");

    $query = "SELECT * FROM ranking ORDER BY score DESC LIMIT 10";
    $sql3  = mysqli_query($mysqli,$query);
    $rank = 0;
    while($row = mysqli_fetch_array($sql3)) {
        $rank++;
        echo $row['user']. ";" .$row['score'] .";";
    }

    $mysqli->close();
?>