I thought it was something like that Rudy; but I can't see it. Here is the table structure (which I interpret for 'Show Table' and below that the one row that is in!
********Aha! You led me to it. the _id was not auto-incrememnted; Now how did I...? No I'd better not ask I might get answers! Thanks, But that doesn't seem to have solved it. I'm not even getting any php errors when I try. All that has happened is the one row id has changed from 0 to 1! Joseph # Table structure for table `spw_addresses` # CREATE TABLE `spw_addresses` ( `spw_addresses_id` smallint(10) NOT NULL default '0', `spw_addresses_company` varchar(50) default NULL, `spw_addresses_building` varchar(50) default NULL, `spw_addresses_number` varchar(10) default NULL, `spw_addresses_street` varchar(50) NOT NULL default '', `spw_addresses_street2` varchar(50) default NULL, `spw_addresses_town` varchar(50) NOT NULL default '', `spw_addresses_statecp` varchar(50) default NULL, `spw_addresses_country` varchar(25) NOT NULL default '', `spw_addresses_zipcode` varchar(10) default NULL, `spw_addresses_phone` varchar(20) default NULL, `spw_addresses_fax` varchar(20) default NULL, `spw_addresses_email1` varchar(50) default NULL, `spw_addresses_email2` varchar(50) default NULL, `spw_addresses_email3` varchar(50) default NULL, `spw_addresses_website1` varchar(50) default NULL, `spw_addresses_website2` varchar(50) default NULL, PRIMARY KEY (`spw_addresses_id`), UNIQUE KEY `spw_addresses_company` (`spw_addresses_company`) ) TYPE=MyISAM; # Dumping data for table `spw_addresses` # INSERT INTO `spw_addresses` VALUES (0, '', ' xxx', ' xxx', ' xxx', ' xxx', ' xxx', ' xxx', ' xxx', ' xxx', ' xxx', ' xxx', ' xxx', ' xxx', ' xxx', ' xxx', ' xxxxx'); > > #1062 - Duplicata du champ '0' pour la clef 1 > > mysql says it can't insert because of a duplicate key > > > > could you please do a SHOW TABLE for that table? > > and maybe SELECT * and copy the last few rows here... > > > rudy > > ____ . The WDVL Discussion List from WDVL.COM . ____ > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] > Send Your Posts To: [EMAIL PROTECTED] > To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. > To change subscription settings to the wdvltalk digest version: > http://wdvl.internet.com/WDVL/Forum/#sub > > ________________ http://www.wdvl.com _______________________ > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > > To unsubscribe via postal mail, please contact us at: > Jupitermedia Corp. > Attn: Discussion List Management > 475 Park Avenue South > New York, NY 10016 > > Please include the email address which you have been contacted with. > > ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
