create table problem

[jenniferG]

Our Sever  states a syntax issue here->

Thanks,

Allison

 

$HISTORY_QUERY="CREATE TABLE IF NOT EXISTS SIHISTORY(

      HISTORY_INDEX  INTEGER AUTO_INCREMENT NOT NULL,

      REQUESTNUMBER  INTEGER,

      CAMERAMODEL    VARCHAR(30),

      STOCKNUMBER    VARCHAR(30),

      RCVCONDITION  ENUM('GOOD','FAIR','BAD','TRASH'),

      SHIPPED        DATE,

      RECEIVED      DATE,

      ENTERED        DATE,

      TODAYDATE      timestamp(14),

      PRIMARY KEY(HISTORY_INDEX)";

 

$HISTORY_RESULT=mysql_query($HISTORY_QUERY) or

        die ("Cannot Create HISTORY Table " . mysql_error());

[Psycho]

I made several modifications and made a working query - don't know which changes were the problem.

 

- changed order of auto_increment and null

- eclosed field and table names in back quotes

- change "integer" to "smallint(10)", there is an INT type, but not INTEGER that I am aware

- You need a closing paren at the end for the opening paren after the table name

 

CREATE TABLE IF NOT EXISTS `SIHISTORY` (
       `HISTORY_INDEX`  SMALLINT(10) AUTO_INCREMENT NOT NULL,
       `REQUESTNUMBER`  SMALLINT(10),
       `CAMERAMODEL`    VARCHAR(30),
       `STOCKNUMBER`    VARCHAR(30),
       `RCVCONDITION`   ENUM('GOOD','FAIR','BAD','TRASH'),
       `SHIPPED`        DATE,
       `RECEIVED`       DATE,
       `ENTERED`        DATE,
       `TODAYDATE`     timestamp(14),
       PRIMARY KEY(`HISTORY_INDEX`)

[Barand]

Both versions seem to have the same original problem - there is a closing ")" missing from the end

[Psycho]

Damn copy/paste error!