I have an error in my insert statement

[emekapromise]

Please can anybody help me with this error? "SQLSTATE[42000]: 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 'Usage,Quantity ,UnitCost ,Tax,Vat_5,UnitPrice ,Date_Log ,EntryTime,Reorder_Level' at line 1"

Here is my code:

<code>
$con = new PDO($DSN, $USER, $PWD); $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO head_inventory(Bar_Code ,Serial_Number ,Item_Name,Product_Name,Product_Model ,Cat_Name ,Item_Desc,Usage,Quantity ,UnitCost ,Tax,Vat_5,UnitPrice ,Date_Log ,EntryTime,Reorder_Level,Vendor,UserName)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
$stmt = $con->prepare($sql); $stmt->execute(array('" .$Bar_Code. "','".$Serial_Number."','".$Item_Name."','".$Product_Name."','".$Product_Model."','".$Cat_Name."','" .$Item_Desc."','".$Usage."','".$Quantity."','".$UnitCost."','".$Tax."','".$Vat_5."','".$UnitPrice."' ,'".$Date_Log."','".$EntryTime."','".$Reorder_Level."','".$Vendor."','".$UserName."'));
</code>

[Arcticwarrio]

try backsticks ` ` around the column names, (the key to the left of 1 on a british keyboard)

PHP Code:

$sql = "INSERT INTO head_inventory(`Bar_Code` ,`Serial_Number` ,`Item_Name` ,`Product_Name` ,`Product_Model` ,`Cat_Name` ,`Item_Desc`,`Usage`,`Quantity` ,`UnitCost` ,`Tax` ,`Vat_5` ,`UnitPrice` ,`Date_Log ` ,`EntryTime` ,`Reorder_Level` ,`Vendor` ,`UserName`)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; 


[Fou-Lu]

Yep, in particular the USAGE is a reserved word. That must be backticked in order to use it as a field identifier.

[Arcticwarrio]

also to prevent any errors of this type you might like to read this:

http://en.wikipedia.org/wiki/Hungarian_notation


ie prefix tables with TBL_ eg TBL_head_inventory
and fields with FLD eg FLD_Bar_Code or FLD_Usage