OK, I have no idea why but i have spent the past hour trying to create this
stupid table. I am using the latest version of phpmyadmin. I created the
query several times thru the interface and then played with the query in the
textbox. I need help badly.

CREATE TABLE users (id INT (9) not null  , user VARCHAR (12)  not null ,
pass VARCHAR (45)  not null , permission ENUM  , package INT not null ,
apartment VARCHAR (75)  not null , apt_address VARCHAR (120)  not null ,
apt_city VARCHAR (45)  not null , apt_state CHAR (2)  not null , apt_zip
CHAR (5)  not null , con_first VARCHAR (25)  not null , con_last VARCHAR
(30)  not null , con_phone VARCHAR (15)  not null , con_phone_2 VARCHAR (15)
not null , con_fax VARCHAR (15)  not null , con_email VARCHAR (70)  not null
, bill_first VARCHAR (25)  not null , bill_last VARCHAR (30)  not null ,
bill_address VARCHAR (120)  not null , bill_city VARCHAR (45)  not null ,
bill_state CHAR (2)  not null , bill_zip CHAR (5)  not null  )

I would like my table to look like this. I have tried removing the INT
limit. I have no idea why this is not working.

the error that returns says:
MySQL said: You have an error in your SQL syntax near ' package INT not null
, apartment VARCHAR (75) not null , apt_address VARCHAR (' at line 1

I have tried creating the table as type myisam and still no luck.

Thank you,
olinux


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to