Untitled

<!DOCTYPE html>
<html>
<body>

<?php
$servername = "localhost";
$username = "frontend";
$password = "frontend";
$dbname = "info2";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "SELECT DAY, MO, MC, ANO,ANC FROM OPEN";
$result = mysqli_query($conn, $sql);

?>
<table>

<?php

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
?>
    <tr>
    <td>a</td>
    <td>b</td>
    <td>c</td>
    </tr>
<?php
        // echo "Day: " . $row["DAY"]. " - Morning: " . $row["MO"]. " - " . $row["MC"]."  -Afternoon: ". $row["ANO"]. " - " . $row["ANC"]. "<br>";
    }
} else {
    echo "0 results";
}

mysqli_close($conn);
?>

</table>

</body>
</html>
RAW Paste Data