Error during inserting data in a table using the insert form
-
I tried to insert data into a table in the database using this form:
[abase2 form=”1,insert” table=”client’s information” columns=”Name!’width:75px;’,Surename!’width:75px;’,E-mail!’width:125px;’,Phone!’width:75px;’,Fiscal Code!’width:100px;’,Invoice Number!’width:100px;’, Total Invoice!’width:50px;’, Description!’width:175px;’,Date!’width:50px;’$Submit” elements=”Name,Surename,E-mail,Phone,Fiscal Code,Invoice Number, Total Invoice, Description,Date” ack=”red” center=”*”? style=”font-weight: bold; background: #f5f5f5; border-collapse: separate; box-shadow: inset 0 1px 0 #fff; font-size: 13px; line-height: 24px; margin: 30px auto;”]
but I got this error after submit the data:
Couldn’t perform query (1312): SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = ‘database_project1’ AND TABLE_NAME = ‘
client's information‘ – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘s information`” at line 1.can anyone help me to solve this error?
Thanks in advance.
- The topic ‘Error during inserting data in a table using the insert form’ is closed to new replies.
