I to have about 16 text fields in my db that are NOT NULL and they work
Just an observation.
"Lisi" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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?
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