|
G
g_parry author
I'd appreciate a fresh pair of eyes on this code - I'm getting ann error message Incorrect syntax near ", but I've looked and looked and really can't find it
Any help PLEASE <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=22479&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />
global $conn;
$strSQLInsert = "INSERT INTO tblTestPeople
(
psnPersonID,
psnYear,
psnType,
psnIndexName,
psnTitle,
psnForename,
psnInitials,
psnSurname,
psnUsername,
psnDepartment,
psnTelephone,
psnEmail,
psnFTE,
psnLeavingDate,
psnSiteResident,
psnPostCode,
psnDD,
psnDDAuthorised,
psnSalaryFrequency,
psnDeductionToday,
psnSecureName,
psnNonRegistered,
psnFlag,
psnModified)
VALUES
(
".$values["apnPersonID"].",
'".$values["apnYear"]."',
'".$values["apnType"]."',
'".$values["apnIndexName"]."',
'".$values["apnTitle"]."',
'".$values["apnForename"]."',
'".$values["apnInitials"]."'.
'".$values["vclSurname"]."',
'".$values["apnUsername"]."',
'".$values["apnDepatment"]."',
'".$values["apnTelephone"]."',
'".$values["apnEmail"]."',
'".$values["apnFTE"]."',
'".$values["apnLeavingDate"]."',
'".$values["apnSiteResident"]."',
'".$values["apnPostCode"]."',
'".$values["apnDD"]."',
'".$values["apnDDAuthorised"]."',
'".$values["apnSalaryFrequency"]."',
'".$values["apnDeductionToday"]."',
'".$values["apnSecureName"]."',
'".$values["apnNonRegistered"]."',
'".$values["apnFlag"]."',
'".$values["apnModified"]."')";
db_exec($strSQLInsert,$conn);
|
|
