I'm working hard on a custom shopping cart system and all the tables have gone into the DB perfectly except for this one and I can't figure it out. Hopefully one of you kind lads can help out:
PHP Code:
CREATE TABLE order (
order_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
order_date VARCHAR(100),
order_lastupdate VARCHAR(100),
order_status VARCHAR(40),
order_first VARCHAR(20),
order_last VARCHAR(60),
order_email VARCHAR(255)
);
Error:
MySQL said: Documentation
#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 'order (
order_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
order_date VARCHAR(1',
or' at line 1
|