CS75 Buses: Booking
";
$sql=sprintf("INSERT INTO history VALUES ('%s', %d, %d)", $name, $tickets, $bus_id);
mysql_query($sql);
$sql=sprintf("UPDATE buses SET seats=seats-%d WHERE ID=%d", $tickets, $bus_id);
mysql_query($sql);
?>
Booking successful!
Do you want to search for more buses, or book tickets?
You can also search for a passenger or view history!