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]
