Unknown column ' name ' in ' field list; Please help me

Error:you has an error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-to-use ") ' at line 2

Reply to discussion (solution)

Are there two error hints?
Echo $sql; Post the results and see.

Unknown column ' name ' in ' field list;
The name field does not exist, please check

Error:you has an error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-to-use ") ' at line 2

$sql = "INSERT into Shopsystem (Name,tel,email,qq,addr,sex,brandname,commoditybrand,productid,ordername,shopname, Shopaddr,invoicenumber,purchasingdate)
VALUES (' $name ', ' $tel ', ' $email ', ' $QQ ', ' $addr ', ' $sex ', ' $brandname ', ' $commoditybrand ', ' $productID ', ' $ordername ', ' $shopname ', ' $shopaddr ', ' $invoicenumber ', ' $purchasingdate ');
if (!mysql_query ($sql, $conn))

Try to add a space before the values.

Field errors can also be single quote problems, numbers, dates, etc. without quotation marks

Shopsystem (NAME,TEL,EMAIL,QQ,ADDR,SEX,BRANDNAME,COMMODITYBRAND,PRODUCTID,ORDERNAME,SHOPNAME,SHOPADDR, Invoicenumber,purchasingdate) The fields in this field are all used ' name ', ' Tel ', so try, the key below the ESC

Single-quote problem.
Suggested stitching

$sql = "INSERT into Shopsystem (Name,tel,email,qq,addr,sex,brandname,commoditybrand,productid,ordername,shopname, Shopaddr,invoicenumber,purchasingdate) VALUES (' ". $name." ', ' ". $tel." ', ' ....    .

