add_styles_page();
$db = new db_safeguard();
$bookings_res = $db->query("bookings", "SELECT * FROM bookings WHERE status ='ATTEMPT'");
if ($bookings_res->num_rows > 0) {
while ($bookings = $bookings_res->fetch_assoc()) {
$test_res = $db->query("tests", "SELECT * FROM tests WHERE record_id = '{$bookings['test_id']}'");
$test = $test_res->fetch_assoc();
$table_data = $table_data . "
| {$bookings['booking_no']} |
{$bookings['date_booked']} |
{$bookings['assigned_to']} |
{$test['name']} |
{$bookings['status']} |
|
";
}
} else {
$table_data = $table_data . "
| |
|
No Bookings Found |
|
|
";
}
?>