Using PHP to submit data to MYSQL Database

Question

Hi I am developing a website that has users fill in a form and submit data to a database but I can't get any of it to submit. Please can someone help me find the problem. Thanks.

Here is the pages PHP/HTML.

http://pastebin.com/8jfWrByd

and here is the table's layout

http://pastebin.com/E06Ac8Yx

When I go to try and post an item I get the following error

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 'Desc, Tips) VALUES ('Base Invaders', 'Ron', '27', '12500', '850', '1', '4', 'TP ' at line 1

Please help me!

Barmar · Accepted Answer · 2013-11-11 02:05:01Z

3

DESC is a reserved word. If you want to use it as a column name, you have to quote it with backticks.

answered Nov 11, 2013 at 2:05

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2977587 Over a year ago

Thanks, How could I be so blind!

Collectives™ on Stack Overflow

Using PHP to submit data to MYSQL Database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related