Untitled

<!DOCTYPE html>
<html>
<head> <title> Database </title> </head>
<body>
<?php

echo "hei";

$servername = "localhost";
$username = "root";
$password = "illievski";
$dbname = "hioa";

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

if ($conn->connect_error) {
    die("Tilkobling til database feilet: " . $conn->connect_error);
}
mysqli_set_charset($conn,"utf8");


$sql = " SELECT * FROM hioa.lol WHERE tureningsnummer = 3";
$result = $conn->query($sql);
$retval = mysql_query( $sql, $conn );


echo "<table>"; // start a table tag in the HTML

while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) {
    echo "<tr><td>" . $row['lagnavn'] . "</td><td>" . $row['lagkaptein'] . $row['spiller2'] . $row['spiller3'] .
. $row['spiller4'] .  $row['spiller5'] . $row['emailkaptein'] ."</td></tr>";  //$row['index'] the index here is a field name
}

echo "</table>"; //Close the table in HTML

$conn->close();

?>
</body>
</html>