SQL Table error - Webmaster Forum - Web Design, Programming and SEO forums

10-20-2007, 11:43 PM

Adam S.

Status: Senior Member
Join date: Aug 2006
Location: New Brunswick, Canada
Expertise: Coding / programming
Software: NotePad

Posts: 824

iTrader: 9 / 100%

Adam S. is on a distinguished road

SQL Table error

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

10-20-2007, 11:53 PM

Andrew R

Status: Request a custom title
Join date: Dec 2005
Location: Arizona
Expertise:
Software:

Posts: 5,200

iTrader: 17 / 95%

Andrew R is on a distinguished road

I believe that "PRIMARY KEY" has to go at the end of the line. Also, I think you also have to add a number to INT such as INT(5). Haven't used SQL in a while though.

10-21-2007, 12:41 AM

Lee_

Status: Member
Join date: Jun 2006
Location: UK
Expertise:
Software:

Posts: 184

iTrader: 2 / 100%

Lee_ is on a distinguished road

PHP Code:


			
CREATE TABLE `order` (

`order_id` INT(11) NOT NULL 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),

PRIMARY KEY  (`order_id`)

);

Edit: Tested that on my localhost and it works.

10-21-2007, 01:31 PM

Adam S.

Status: Senior Member
Join date: Aug 2006
Location: New Brunswick, Canada
Expertise: Coding / programming
Software: NotePad

Posts: 824

iTrader: 9 / 100%

Adam S. is on a distinguished road

Works great, thanks for the help guys.