RE: [PHP-DB] MySQL Error???

Thanks guys. It was all very helpful and worked great! Brian -----Original Message----- From: Christian Sandfeld [mailto:csa@zen-sys.com] Sent: Thursday, June 28, 2001 3:06 AM To: 'Brian Grayless'; 'php-db@lists.php.net' Subject: RE: [PHP-DB] MySQL Error??? Brian, Sounds to me as if the field you have as primary key is set to type 'TINYINT'. TINYINT's 'signed' range accepts values from -128 to 127, when set to 'unsigned' it accepts values from 0 to 255. In your place I would concider changing that column to a 'SMALLINT' and set it to 'unsigned'. This will allow for values from 0 to 65535 (depending ofc. on how many digits you set as the max display size). Hope I helped :) /Christian -----Original Message----- From: Brian Grayless [mailto:bgrayless@Premier-Resorts.com] Sent: 27. juni 2001 18:24 To: PHP DB list (E-mail) Subject: [PHP-DB] MySQL Error??? Is anyone familiar with this MySQL error? "1062: Duplicate entry '127' for key 1" I wrote a great bookmark management program that works fine, but everytime I insert bookmarks, I insert somewhere over 120 and I start getting this error, and it won't add them anymore. Any suggestions??? Thanks, B R I A N G R A Y L E S S Web Administrator Premier Resorts www.premier-resorts.com P: 435-655-4812 F: 413-618-1518 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net