Sending data from html t mysql Error

Asked Apr 03 '18 at 18:57

Active Apr 03 '18 at 19:07

Viewed 23 times

That is the code error

Syntax error or access violation: 1064 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 'order,visibility,comment,add) VALUES 
('cake', 'wonderful ', '1','0', '0'' at line 2

edited Apr 03 '18 at 19:07

Barmar

741,623
53
500
612

asked Apr 03 '18 at 18:57

maria

2

Sounds like `order` is a reserved word. Wrap table/column names in back-ticks to explicitly tell the database that they are table/column names and not keywords. – David Apr 03 '18 at 19:01
https://dev.mysql.com/doc/refman/5.7/en/keywords.html – AbraCadaver Apr 03 '18 at 19:01
2

We hate images. – Jaxon Crosmas Apr 03 '18 at 19:05
Please post code as text in future – RiggsFolly Apr 03 '18 at 19:16
thanks i've changed the names and it works – maria Apr 03 '18 at 22:17

Sending data from html t mysql Error

0 Answers0