Hi,
I'm trying to enter some data into MySQL, but I keep getting this error:
PHP Code:
Error in query: INSERT INTO product (stock_num, series, name, thread_id, dim_h, dim_w, dim_l, weight, case) VALUES ('10999a', 's12', 'test tein', '325', '123.6', '123', '423', '123.67', '4'). 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 'case) VALUES ('10999a', 's12', 'Wulfe Stein', '325', '123.6', '
This is the structure of the 'product' table:
PHP Code:
inv_id int(255) UNSIGNED No auto_increment
stock_num varchar(255) No
series varchar(255) No
name varchar(255) No
thread_id int(255) UNSIGNED No 0
dim_h varchar(255) No 0
dim_w varchar(255) No 0
dim_l varchar(255) No 0
weight varchar(255) No
case varchar(10) No 0
Please help!