[SOLVED] Help Creating Table

[smstromb]

This should be an easy fix but my eyes just cannot spot the error, it's driving me crazy:

 

$sql = "CREATE TABLE $username (

id int NOT NULL AUTO_INCREMENT,

PRIMARY KEY (id),

  FlightNumber varchar(5) NOT NULL,

  Date date NOT NULL,

Approach varchar(100) NOT NULL,

IMC smallint(6) NOT NULL,

  NightLandings smallint(6) NOT NULL,

  NightTime smallint(6) NOT NULL,

  Depart varchar(5) NOT NULL,

  Arrive varchar(5) NOT NULL,

  BlockTime smallint(6) NOT NULL,

  Aircraft varchar(10) NOT NULL,

  AircraftType varchar(10) NOT NULL,

  )";

 

        mysql_query($sql,$this->connection);

[rhodesa]

Date is a reserved word, don't use it as a column name

 

 

....also, this should be posted in mysql help

[smstromb]

Ah, Sorry. Was in such a rush I didn't even look for the mysql forum. Also, I changed Date to theDate and it's still giving me problems.

[.josh]

mysql_query($sql,$this->connection) or die(mysql_error());

[smstromb]

problem solved. There's an extra comma right before the closing parenthesis.