Please attach the page when asking for help so I can open it in Dreamweaver and see it in context. I don't think this is the correct technique for this result. There are a variety of issues I can see, but I'd rather suggest a different approach.
You might consider using the "Execute Query" server behavior instead of the recordset and insert and hidden fields. All of this complexity can be avoided.
Just execute a query like:
php:
<?php
if (isset($_POST["submit"]) || isset($_POST["submit_x"])) {
$ExecuteQuery = new WA_MySQLi_Query($vpleaguedb);
$ExecuteQuery->Statement = "INSERT INTO courses (course_number, course_title, stateID, departmentID, `status`, description, notes, core_elective, `year`, subcategory, grade_level, pre_reqs, credit_assignment) (SELECT course_number, course_title, stateID, departmentID, 'Proposed' AS `status`, description, notes, core_elective, ? AS `year`, subcategory, grade_level, pre_reqs, credit_assignment FROM courses WHERE **your current rollover_selection filter**";
$ExecuteQuery->bindParam("i", "".($_GET['rollover_year']) ."", "-1"); //yearparam
$ExecuteQuery->execute();
$ExecuteGoTo = "home.php";
if (function_exists("rel2abs")) $ExecuteGoTo = $ExecuteGoTo?rel2abs($ExecuteGoTo,dirname(__FILE__)):"";
$ExecuteQuery->redirect($ExecuteGoTo);
}
?>
Then you can remove the insert, recordset, and hidden form elements on your page.
Did this help? Tips are appreciated...
