SQL错误消息:


SQL Error message:

有人能帮我找出我做错了什么吗?

当我按下表单上的提交时,我收到了这个错误消息:

您的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')