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

I was using MS Access 2000 and did not have the problem. I am now using
MySQL and all insert queries add 2 recs?!


$sql = "INSERT INTO Campaign
stratorId) VALUES


if (!$res_insert_campaign) {
  return false;

With the

CampaignId      CompanyId       AdministratorId CampaignName    CampaignDes     
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
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.


PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to