[Solved] SQL Error message: [closed]

by


Hard to guess without as much details as needed, but i think you are escaping the values with aphostropes ('). That’s php’s habit. MySQL doesn’t escape those values with aphostropes, it uses backtiks (`) or nothing. You could change your query part which you provided to remove those symbols:

…

2013-12-10, NULL, dsffsd, dfsfsd, sfdd, sdffsd, sdfsdf, sfdsdf, dsad

…

Edit:

You have writed space between values and (). No space needed. Change it like this:

INSERT INTO clients (caseref, casetype, clienttitle, clientforename, clientsurname, 
submitdate, clientdob, clienttelhome) VALUES('$caseref', '$casetype', '$clienttitle', 
'$clientforename', '$clientsurname', '$submitdate', '$clientdob', '$clienttelhome')

2

solved SQL Error message: [closed]