Re: Re: Error creating new table

For the record, the problem was assigning a length to a text field. The NOT NULL part is fine. Thanks everyone for your input! -Lisi At 04:59 PM 4/8/02 -0700, Jennifer Downey wrote:

I to have about 16 text fields in my db that are NOT NULL and they work fine. Just an observation. Jennifer "Lisi" <lists@shemeshdirectory.co.il> wrote in message news:5.0.0.25.0.20020408110854.00a199f0@web.maxinvest.com... 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.344 / Virus Database: 191 - Release Date: 4/2/2002 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php