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]