[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

Re: [PHP-DB] Error creating new table

, 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

Re: [PHP-DB] Error creating new table

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

Re: [PHP-DB] Error creating new table

AM Subject: Re: [PHP-DB] Error creating new table Worked like a charm, thanks. How do I avoid varchar if I the size of the text will vary with each entry? It's going to be a pretty small database anyway so I'm not that worried, but how often do I optimize the table to avoid fragmentation