SQL Server incorrect syntax near the keyword 'order'

Question

The Error code is: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword 'order'. ) )

$tsql = "INSERT INTO dbo.order(client,
contact,
vendor,
iteminfo,
ourcost,
ourshipping,
pricequote,
shipquote,
shipinfo,
requestor)
  VALUES (?,?,?,?,?,?,?,?,?,?)";

$params = array(&$_POST['client'],
&$_POST['contact'],
&$_POST['vendor'],
&$_POST['iteminfo'],
&$_POST['ourcost'],
&$_POST['ourshipping'],
&$_POST['pricequote'],
&$_POST['shipquote'],
&$_POST['shipinfo'],
&$_POST['requestor']);

This is just about identical to another table I've got and it works just fine. What am I missing here?

`order` is a reserved word put it in []'s `INSERT INTO dbo.[order](client,` or change the name of the table to not use keywords. — xQbert, Aug 25 '16 at 20:17
Sure, I'm still trying to get used to the format of the site. — Alex_TCD, Aug 25 '16 at 21:45

score 0 · Accepted Answer · answered Aug 25 '16 at 21:48

0

order is a reserved word put it in []'s INSERT INTO dbo.[order](client, or change the name of the table to not use keywords

answered Aug 25 '16 at 21:48

xQbert

34,733
2
41
62

SQL Server incorrect syntax near the keyword 'order'

1 Answers1