Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001072

RE: [PHP-DB] phpmyadmin troubles - creating tables From: Beau Lebens (B.Lebens <email protected>)
Date: 07/24/01

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:olnx <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  <email protected> address at http://mail.yahoo.com
//
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, e-mail: php-db-unsubscribe <email protected>
// For additional commands, e-mail: php-db-help <email protected>
// To contact the list administrators, e-mail:
// php-list-admin <email protected>
// 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>