require 'header.php' ?>
require 'sidebar.php' ?>
Dashboard
Overview
$results = $db->query("SELECT count(*) FROM cars WHERE test_reg = 'N'"); foreach($results as $row) { echo $row['0']; } echo " Pre-Registrations!"; ?>
$query = "SELECT count(*) FROM cars WHERE previously_attended = 'pa_N' AND test_reg = 'N'"; $results = $db->query($query); foreach($results as $row) { echo $row['0']; } echo " New Registrations"; ?>
$query = "SELECT count(*) FROM cars WHERE reg_date = CURDATE() AND test_reg = 'N'"; $results = $db->query($query); foreach($results as $row) { echo $row['0']; } echo " Registrations Today"; ?>
$query = "SELECT count(*) FROM cars WHERE checked_in = 'Y' AND test_reg = 'N'"; $results = $db->query($query); foreach($results as $row) { echo $row['0']; } echo " Check-ins"; ?>
require 'footer.php'; ?>