Hello, The length of VARCHAR must be specified like;
CREATE TABLE sailordata ( sailorid INT(8) NOT NULL DEFAULT 0, lastname VARCHAR(255) NOT NULL, firstname VARCHAR(255) NOT NULL, middlenames VARCHAR(255) NOT NULL, dob VARCHAR(255) NOT NULL, telephone VARCHAR(255) NOT NULL, fax VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL); Regards, Hiroshi Ayukawa http://hoover.ktplan.ne.jp/kaihatsu/php_en/index.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php