<?php
    $servername = "localhost";
    $username = "root";
    $password = "root";
    $dbname = "score";


    $conn = new mysqli($servername, $username, $password, $dbname);

    if ($conn->connect_error) {
         die("Connection failed: " . $conn->connect_error);
    }

    $sql = "SELECT id, name, description FROM all_scores ORDER BY id DESC LIMIT 5";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {

         while($row = $result->fetch_assoc()) {
             echo "<p></p>";
             echo "<a href=score2/view.php>". $row["name"]. "</a>";
                 echo "<p>". $row["description"]. "</p>";
         }
    } else {
         echo "0 results";
    }

    $conn->close();
?>