Change the gradient definition to: gradient MEDIUMINT(10) NOT NULL AUTO_INCREMENT, > -----Original Message----- > From: Jeff [mailto:jroth1@telus.net] > Sent: Tuesday, August 05, 2003 1:44 PM > To: php-db@lists.php.net > Subject: Re: MySQL Returns Error > > > Ok, that worked, > > Now the error I'm getting is "Duplicate entry ' ' for key 1" > > Is this a SQL table error? > > Here's my Table as entered: > > CREATE TABLE gradients ( > gradient MEDIUMINT(10) DEFAULT '0' NOT NULL AUTO_INCREMENT, > ......... > tag VARCHAR(15) NOT NULL, > PRIMARY KEY (lsd), > UNIQUE gradient (gradient) > ); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
