MySQLi form (not basic)

I attached 2 pages that I'm working with.

The form on the first page (kids_insert_shift.php) has a checkbox for recurring.

If the recurring checkbox is checked when the form is submitted, then I need the second page to open (kids_insert_shift_recurring.php).

I also need the second page to retrieve the ID number from the kids_program_shifts table row that was created when the kids_insert_shift.php form was submitted (It's an Auto Increment, so it doesn't exist until the first form is submitted), and put it in the hidden "ShiftID" field.

you will need to hand code the redirect
<?php
if(isset($_POST["Recurring"]) && $_POST["Recurring"] == "1") {
header("Location: kids_insert_shift_recurring.php);
}
?>


in the insert behavior, ther is a section for Save ID In Session As, enter a name for the session variable there, then on the kids_insert_shift_recurring.php use the session to filter the recordset.

I'm getting a syntax error with the redirect:

$InsertGoTo = "<?php if(isset($_POST"Recurring"]) && $_POST["Recurring"] == "1") {header("Location: kids_insert_shift_recurring.php);}?>";

because that code cannot be used as the redirect in the insert behavior, it has to be added after the insert behavior.


you cannot do a conditional redirect directly in the insert behavior, you have to hand code that outside of the insert behavior.

Ok, Thanks! (there was a missing quote also thought) lol

Can you be more specific on how to filter the session id in the recordset on the kids_insert_shift_recurring.php page?

create a recordset on the page, in the filtering section, select the ID column, use the equals comparison, for the filter type, select session, for the name enter the name you used in the insert for the Save ID isn Session named section.

PERFECT! Thank you!

you're welcome.