Why am I getting a MySQLi Syntax error?

[Samishii23]

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) VALUES (?,?)' at line 1
Syntax:

INSERT INTO equip_type (name, desc) VALUES (?,?)

Other Syntax on my program that works:

INSERT INTO equipment (name,purchasedate,purchaseprice,type,lastrepair,serial,usagetype,usageval,brand,dateadded,notes) VALUES (?,?,?,?,?,?,?,?,?,?,?)

I can't see the problem... Any help?

[JKing]

Throw some back ticks around desc and try again. DESC is a reserved word.

Here is a link if you want some more information on reserved words/keywords in mysql: MySQL Reserved Words

[Wiinie]

you have to check your spelling and desc table again .. make sure everything is correct spelling in table's structure

[chetan9529]

Second statement is fine.. First having issue because you are using "desc" as column name. It is not possible as "desc" is reserved key word for sorting a column.. create table that having column name as "name" and "descriptio n". Then insert into that.. :)