$future[$n] = "
$firstName $lastName
$email
$voicemail
$start_date2
$end_date2
"; print qq~

Future Out of Office List

~; print qq~

~; print qq~The following will be out of the office until the date specified:~; print qq~


~; print qq~
EmployeeChecking E-mailChecking VoicemailLeavingReturning~; for($i = 0; $i < @future; $i++) { print qq~$future[$i]~; } print qq~
~; } #### if($session_cgi->param("delete")) { $firstName = $session_cgi->param("firstName"); $lastName = $session_cgi->param("lastName"); $startdate = $session_cgi->param("start_date"); $enddate = $session_cgi->param("end_date"); $db = dbLoad($db); $select_statement = "SELECT id FROM Employees WHERE lastName = '$lastName' and firstName = '$firstName'"; $select_it = $db->prepare($select_statement); $rc = $select_it->execute() or die "Could not run query '$select_statement'\n"; $select_it->bind_columns(undef, \$user_id); $select_it->fetchrow_arrayref(); $statement = "DELETE FROM Out_Of_Office WHERE id = '$user_id' and start_date = '$start_date' and end_date = '$end_date'"; $statement = $db->prepare($statement); $rv = $statement->execute() or die "Couldn't execute query '$query' \n"; $db->disconnect();