There is an error in your SQL syntax, yet rsobj.php has $this->Debug = true;
...leaving me with no way of diagnosing an issue. :(
How do I resolve this?
Thank you.
NJ
EDIT: this is occurring when I add the following MySQLi Insert Record behaviour to the page:
<?php
if (isset($_POST["btnADDSTEP1"]) || isset($_POST["btnADDSTEP1_x"])) {
$InsertQuery = new WA_MySQLi_Query($csdbmysqli);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "SMCform";
$InsertQuery->bindColumn("SMCformFIRST", "s", "".((isset($_POST["FirstName"]))?$_POST["FirstName"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMCformLAST", "s", "".((isset($_POST["Surname"]))?$_POST["Surname"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMCformEMAIL", "s", "".((isset($_POST["EmailConfirm"]))?$_POST["EmailConfirm"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMCformADD", "s", "".((isset($_POST["Address"]))?$_POST["Address"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMCformADD1", "s", "".((isset($_POST["Address2"]))?$_POST["Address2"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMCformCITY", "s", "".((isset($_POST["City"]))?$_POST["City"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMCformREGION", "s", "".((isset($_POST["Region"]))?$_POST["Region"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMCformCOUNTRY", "i", "".((isset($_POST["Country"]))?$_POST["Country"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMCformZIP", "s", "".((isset($_POST["Postcode"]))?$_POST["Postcode"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMCformPHONE", "s", "".((isset($_POST["Telephone"]))?$_POST["Telephone"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMCformMOBILE", "s", "".((isset($_POST["Mobile"]))?$_POST["Mobile"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMCformDOB", "t", "".((isset($_POST["DOB"]))?$_POST["DOB"]:"") ."", "WA_DEFAULT");
$InsertQuery->saveInSession("NEWformID");
$InsertQuery->execute();
$InsertGoTo = "health-screening-form.php?tab2=1";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>
I've tripled checked the database column names and the form field names and it's all fine.