The problem is that he assigned a length to a TEXT field. You cannot do that.
-----Original Message----- From: George Pitcher [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:13 AM To: [EMAIL PROTECTED]; Lisi Subject: Re: [PHP-DB] Error creating new table You can't have NOT NULL assigned to a text field. george ----- Original Message ----- From: "Lisi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 10: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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php