有人能帮我找出我做错了什么吗?
当我按下表单上的提交时,我收到了这个错误消息:
您的SQL语法有错误;在第8行的"2013-12-10"、"、"dsffsd"、"dfsfsd"、"sfdd"、"sdffsd"、"sdfsdf"、"sfdsdf"、"dsad"附近,请查看与MySQL服务器版本对应的手册,以获取要使用的正确语法
这是第8行的php代码:
function renderForm($caseref, $casetype, $clienttitle, $clientforename, $clientsurname,
$clientdob, $clienttelhome, $clienttelwork, $clienttelmob, $clientemail,
$clientaddress1, $clientaddress2, $clientaddress3, $clientaddress4, $clientaddress5,
$clientpostcode, $clientoccupation, $clientni, $defendanttitle, $defendantforename,
$defendantsurname, $defendantaddress1, $defendantaddress2, $defendantaddress3,
$defendantaddress4, $defendantaddress5, $defendantpostcode, $defendantvehiclereg,
$defendantpolicyno, $defendantinsurername, $defendantcomments, $softtissue, $boneinjury,
$whiplash, $injurydescription, $timeoffwork, $medicalattention, $attendedhospital,
$hospitalname, $hospitaladdress1, $hospitaladdress2, $hospitaladdress3,
$hospitaladdress4, $hospitaladdress5, $hospitalpostcode, $claimantposition,
$passengernumber, $claimantseatbelt, $ownertitle, $ownerforename, $ownersurname,
$owneraddress1, $owneraddress2, $owneraddress3, $owneraddress4, $owneraddress5,
$ownerpostcode, $drivertitle, $driverforename, $driversurname, $driveraddress1,
$driveraddress2, $driveraddress3, $driveraddress4, $driveraddress5, $driverpostcode,
$clientvehiclemake, $clientvehiclemodel, $clientvehiclereg, $clientinsurername,
$clientpolicyno, $doa, $timeaccident, $accidentlocation, $weatherconditions,
$roadconditions, $accidentcircumstances, $policereported, $namepolice, $incidentref,
$otherinfo, $submitdate, $error)
查询:
INSERT INTO clients (caseref, casetype, clienttitle, clientforename, clientsurname,
submitdate, clientdob, clienttelhome) VALUES ('$caseref', '$casetype', '$clienttitle',
'$clientforename', '$clientsurname', '$submitdate', '$clientdob', '$clienttelhome')
如果没有所需的那么多细节,很难猜测,但我认为您正在使用Apostropes('
)来转义这些值。这是php的习惯。MySQL不使用aphostropes来转义这些值,它使用backtiks(`)或什么都不使用。您可以更改您提供的查询部分以删除这些符号:
2013-12-10, NULL, dsffsd, dfsfsd, sfdd, sdffsd, sdfsdf, sfdsdf, dsad
编辑:
您在值和()之间写入了空格。不需要空间。这样改:
INSERT INTO clients (caseref, casetype, clienttitle, clientforename, clientsurname,
submitdate, clientdob, clienttelhome) VALUES('$caseref', '$casetype', '$clienttitle',
'$clientforename', '$clientsurname', '$submitdate', '$clientdob', '$clienttelhome')