Avatar of David Schure
David Schure

asked on 

Not Displaying Result

Query is not displaying the result on my webpage...
<?php
    $sql = <<<EOT SELECT COUNT(*) FROM tbl_session AS NUMBER
      WHERE session_date=CURDATE()
      AND session_status="Booked";
      EOT;
$result = $db->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "NUMBER". $row["NUMBER"]."<br>";
    }
} else {
    echo "0 results";
}
   ?> 

Open in new window

PHP

Avatar of undefined
Last Comment
David Schure

8/22/2022 - Mon