function updateAssignment($link, $table) { // update assignments $year = substr($table, -4, 4); $query = "select * from {$table}"; $statement = $link->prepare($query); $rc = $statement->execute(); if (!$rc) { $errNum = mysqli_errno($link); $errMsg = mysqli_error($link); print " ERROR - could not register selection: ErrNo=" . mysqli_errno($link) . ": " . mysqli_error($link) . "\n"; exit; } $statement->bind_result($task, $person); $i = 0; $updates = ""; while ($statement->fetch()) { $myTask = new TeachingTask($task); $myTask->updateYear($year); if ($myTask->generateId() != $myTask->getId()) { $updates[$i] = "update {$table} set Task='" . $myTask->generateId() . "' where Task='" . $myTask->getId() . "'"; $i = $i + 1; } } // Now perform the updates foreach ($updates as $key => $update) { print " execute update: {$update} <br>\n"; $statement = $link->prepare($update); $rc = $statement->execute(); if (!$rc) { $errNum = mysqli_errno($link); $errMsg = mysqli_error($link); print " ERROR - could not update assignments: ErrNo=" . mysqli_errno($link) . ": " . mysqli_error($link) . "\n"; exit; } else { print " INFO - entry updated.<br>\n"; } } }