troubleshooting Question

Not Displaying Result

Avatar of David Schure
David Schure asked on
PHP
11 Comments1 Solution15 ViewsLast Modified:
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";
}
   ?> 
ASKER CERTIFIED SOLUTION
Dan Craciun
IT Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros