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();