mysql table

[tim.j]

CREATE TABLE sites(id INT( 10 ) NOT NULL AUTO_INCREMENT ,
username VARCHAR( 16 ) ,
PASSWORD VARCHAR( 16 ) ,
name VARCHAR( 50 ) ,
email VARCHAR( 50 ) ,
sitename VARCHAR,
sitedescription VARCHAR( 50 ) ,
date VARCHAR( 50 ) ,
PRIMARY KEY ( id )
);



MySQL said:


#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 '
sitedescription VARCHAR( 50 ) ,
date VARCHAR( 50 ) ,
PRIMAR
Any idea what's wrong help would be appreciated

[tim.j]

Never mind I got it

[SilentMind]

How did you solve it? .. I got the same problem, you know.. But I havent solved it yet. :puzzled:

[tim.j]

Instead of typing that up just go to phpmyadmin click on your database close to the bottom there's this:
Create new table on database "your database's name" :
Name : "type up what you wan't the name of your table name to be"
Fields : "type the number of fields you want"
click "go" then you can customize your fields.