[PHP-DB] Error creating new table

[Lisi]

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