Re: Error creating new table

Worked like a charm, thanks. How do I avoid varchar if I the size of the text will vary with each entry? It's going to be a pretty small database anyway so I'm not that worried, but how often do I optimize the table to avoid fragmentation? -Lisi At 10:29 AM 4/8/02 +0200, you wrote:

I don't think you can use text(50), It should be one of the following tinytext, mediumtext or text Or you should use char(50). I would try to avoid using varchar() it fragments the database. Remco ----- Original Message ----- From: "Lisi" <lists@shemeshdirectory.co.il> To: <php-db@lists.php.net> Sent: Monday, April 08, 2002 11:11 AM Subject: [PHP-DB] Error creating new table I am trying to create the following table using PHPMyAdmin: CREATE TABLE IF NOT EXISTS ayny(

         organization varchar(50) NOT NULL,
         subtitle varchar(50) NOT NULL,
         img varchar(20) NOT NULL,
         width varchar(5),
         height varchar(5),
         link varchar(30) NOT NULL,
         maintext text(50) NOT NULL,
         boxtext text(50) NOT NULL,
         ID INT(9) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY(ID)

); But I keep getting the following error: MySQL said: You have an error in your SQL syntax near '(50) NOT NULL, boxtext text(50) NOT NULL, ID INT(9) NOT NULL AUTO_INCREMENT,' at line 8 Any ideas what I'\m doing wrong? TIA, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php