Tried to send this but got the following message from your server: Warning: Could not execute mail delivery program in /local/Web/sites/phpweb/bugs.php on line 411 Mail not sent! Please send this page in a mail to [EMAIL PROTECTED] manually. So I have: From: [EMAIL PROTECTED] Operating system: WinNT4 PHP version: 4.0.6 PHP Bug Type: MySQL related Bug description: Insert queries add TWO records to database All my insert queries seem to add two records to the database instead of one. I was using MS Access 2000 and did not have the problem. I am now using MySQL and all insert queries add 2 recs?! Eg. $sql = "INSERT INTO Campaign (CampaignName,CampaignDesc,StartDate,EndDate,CompanyId,CampaignStatus,Admini stratorId) VALUES ('$name','$desc','$start_date','$end_date',$company_id,0,1)"; $res_insert_campaign=mysql_query($sql,$conn); if (!$res_insert_campaign) { return false; } With the result: CampaignId CompanyId AdministratorId CampaignName CampaignDes StartDate EndDate ProposalPDF InvoicePDF CampaignStatus 11 45 1 Test All testing 2001-07-03 2003-07-03 NULL NULL 0 12 45 1 Test All testing 2001-07-03 2003-07-03 NULL NULL 0 (2 row(s) affected) A guy in the US seems to be having the same problem with Sybase. His details are: Rob Donat Sedonatech, Inc. 1735 W. Diversey Suite 521 Chicago, IL 60614 [EMAIL PROTECTED] 312-501-1200 cell 773-388-0271(2) office(fax) Do u know if this is a PHP, MySQL, ODBC or server setting bug? My fix at the moment is to insert a record, select it and delete one if 2 are added. This is very messy and I would like to know if I have to go back to Access or start using another relational database? Does anyone else have this problem or, preferebly, how do I fix it? Thank you for any help. mailto:[EMAIL PROTECTED] -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]