Need help with SQL syntax errors
Hi,
All of a sudden I'm having an issue with a few PHP pages that have worked for years. They are pages that pull member info from a database, allow the admins or individual members to alter the info, then post back to the database. For some reason, after changing the data, the form is not posting back but is giving the error message: "There is an error in your SQL syntax." Our server administrator, who is not a developer, says after checking the syntax in the two forms throwing the error, says he gets this response:
$GCSMembership_i = mysqli_init();
if (defined("MYSQLI_OPT_INT_AND_FLOAT_NATIVE")) $GCSMembership_i->options(MYSQLI_OPT_INT_AND_FLOAT_NATIVE, TRUE);
$GCSMembership_i->real_connect($hostname_GCSMembership_i, $username_GCSMembership_i, $password_GCSMembership_i, $database_GCSMembership_i) or die("Connect Error: " . mysqli_connect_error());
He doesn't know what this means nor do I. I am using DW CS 6 and your WebAssist MySQLi add-on. Something has gone south because as I said, these forms were working fine before. I am attaching one form that is processing changes correctly with no errors (update_self.php) and two forms that are giving errors (update_user.php and update_lapsed.php) in the hopes that someone can spot the problem.
Thank you in advance,
Gail