Help on SQL

[x3n_webmaster]

I want to add a table to my database (mysql) using phpmyadmin and this is what I typed.

create table x3n_members
(ID number(3) primary key,
Username varchar(20) unique,
Password varchar(20),
Email varchar(50),
Handle varchar(20),
Since date,
Position varchar(20),
MSN varchar(50),
Admin varchar(20));

From a tutorial that I'm reading this code should not be wrong but it returned: You have an error in your SQL syntax near 'number(3) primary key, Username varchar(20) unique, Pword varchar(20), Email var' at line 1

Can anyone help me??

[akhi003]

it looks like the ID number has a space in it when it should not.

try changing it to ID_number (note the underscore).

nabeel

[x3n_webmaster]

No I dont think so becuase ID is a column name and number(3) is they type of column it is. So I dont think thats it.

[Lars_Berg]

Number is not a supported datatype in Mysql. Use integer instead.

[siwis]

Lars is correct:

CREATE TABLE x3n_members
(ID INT (3) primary key,
Username varchar (20) unique,
Password varchar (20),
Email varchar (50),
Handle varchar (20),
Since date,
Position varchar(20),
MSN varchar(50),
Admin varchar(20));