I am getting a "Error in SQL syntax" message when trying to use the database update record behavior. How do I fix the SQL syntax?
Here is the code generated by Data Bridge:
<?php
// WA DataAssist Update
if (isset($_POST["submit"]) || isset($_POST["submit_x"])) // Trigger
{
$WA_connection = $bbdtnew;
$WA_table = "bbdt_clients";
$WA_redirectURL = "clients-list.php";
if (function_exists("rel2abs")) $WA_redirectURL = $WA_redirectURL?rel2abs($WA_redirectURL,dirname(__FILE__)):"";
$WA_keepQueryString = false;
$WA_indexField = "client_id";
$WA_fieldNamesStr = "firstname|lastname|street_address|city|state|zipcode|email|start_date|areacode|exchange|number|areacode2|exchange2|number2|dog_1|dog_1_breed|dog_2|dog_2_breed|dog_3|dog_3_breed|dog_4|dog_4_breed|dog_5|dog_5_breed|program|price|notes";
$WA_fieldValuesStr = "".($rs_Client->getColumnVal("firstname")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("lastname")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("street_address")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("city")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("state")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("zipcode")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("email")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("start_date")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("areacode")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("exchange")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("number")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("areacode2")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("exchange2")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("number2")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("dog_1")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("dog_1_breed")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("dog_2")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("dog_2_breed")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("dog_3")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("dog_3_breed")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("dog_4")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("dog_4_breed")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("dog_5")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("dog_5_breed")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("program")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("price")) ."" . $WA_AB_Split . "".($rs_Client->getColumnVal("notes")) ."";
$WA_columnTypesStr = "',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,NULL|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|none,none,NULL|',none,''";
$WA_comparisonStr = "=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_fieldValues = explode($WA_AB_Split, $WA_fieldValuesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_where_fieldValuesStr = "".($rs_Client->getColumnVal("client_id")) ."";
$WA_where_columnTypesStr = "none,none,NULL";
$WA_where_comparisonStr = "=";
$WA_where_fieldNames = explode("|", $WA_indexField);
$WA_where_fieldValues = explode($WA_AB_Split, $WA_where_fieldValuesStr);
$WA_where_columns = explode("|", $WA_where_columnTypesStr);
$WA_where_comparisons = explode("|", $WA_where_comparisonStr);
$WA_connectionDB = $database_bbdtnew;
mysql_select_db($WA_connectionDB, $WA_connection);
@session_start();
$updateParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
$WhereObj = WA_AB_generateWhereClause($WA_where_fieldNames, $WA_where_columns, $WA_where_fieldValues, $WA_where_comparisons );
$WA_Sql = "UPDATE `" . $WA_table . "` SET " . $updateParamsObj->WA_setValues . " WHERE " . $WhereObj->sqlWhereClause . "";
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
if ($WA_redirectURL != "") {
if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
$WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];
}
header("Location: ".$WA_redirectURL);
}
}
?>