Multiple Update issue
I have a page that updates multiple records at a time. It sometimes works fine but, sometimes I get this error message:
UPDATE athlete_registrations SET WHERE `registrationID` = ?
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `registrationID` = ?' at line 1
Here is the my update code:
<?php
if (isset($_POST["submit"]) || isset($_POST["submit_x"])) {
$MultipleUpdateConnection = $athletics2;
$MultipleUpdateTable = "athlete_registrations";
$MultipleUpdateRedirect = "edit_office_fields.php?seasonID=".($athlete->getColumnVal("theseason")) ."";
$MultipleUpdateIndexColumn = "registrationID";
$MultipleUpdateIndexColumnType = "d";
$MultipleUpdateIdentifier = "WADA_RepeatID_registrationID";
for ($x=0; $x<sizeof($_POST[$MultipleUpdateIdentifier]); $x++) {
$MultipleUpdateCount = $_POST[$MultipleUpdateIdentifier][$x];
$UpdateQuery = new WA_MySQLi_Query($MultipleUpdateConnection);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = $MultipleUpdateTable;
$UpdateQuery->bindColumn("level4", "s", "".((isset($_POST["level4"."_".$MultipleUpdateCount]))?$_POST["level4"."_".$MultipleUpdateCount]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("physical_date", "t", "".((isset($_POST["physical_date"."_".$MultipleUpdateCount]))?$_POST["physical_date"."_".$MultipleUpdateCount]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("concussion_course2", "t", "".((isset($_POST["concussion_course2"."_".$MultipleUpdateCount]))?$_POST["concussion_course2"."_".$MultipleUpdateCount]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("academic", "s", "".((isset($_POST["academic"."_".$MultipleUpdateCount]))?$_POST["academic"."_".$MultipleUpdateCount]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("impact_testing_date", "t", "".((isset($_POST["impact_testing_date"."_".$MultipleUpdateCount]))?$_POST["impact_testing_date"."_".$MultipleUpdateCount]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("other_medical_info", "s", "".((isset($_POST["other_medical_info"."_".$MultipleUpdateCount]))?$_POST["other_medical_info"."_".$MultipleUpdateCount]:"") ."", "WA_IGNORE");
$UpdateQuery->addFilter($MultipleUpdateIndexColumn, "=", $MultipleUpdateIndexColumnType, $MultipleUpdateCount);
$UpdateQuery->execute();
}
if ($MultipleUpdateRedirect) {
if (function_exists("rel2abs")) $MultipleUpdateRedirect = rel2abs($MultipleUpdateRedirect,dirname(__FILE__));
header("location: " . $MultipleUpdateRedirect);
}
}?>
Any help would be great. Thanks
Lisa