Re: Error creating new table

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 >