you need INT(16) or something, as in in phpmyadmin, enter an integer for the
size of the field as well when defining it :)
// -----Original Message-----
// From: olinux [mailto:[EMAIL PROTECTED]]
// Sent: Tuesday, 24 July 2001 2:08 PM
// To: php-db
// Subject: [PHP-DB] phpmyadmin troubles - creating tables
//
//
// 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]
//
--
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]