Sponsored by NuSphere - PHP Software for PHP Application Developers - On Sale This Week for $100



Go Back   PHP-Editors > Linux, Apache, MySQL > MySQL Help

MySQL Help Post any question relating to MySQL here and hopefully someone can help

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 2004-06-25, 01:45 PM
Keith
Guest
 
Posts: n/a
Default

I have a very strange problem with MySQL. I'm using an AUTO_INCREMENT column as the primary key in one of my tables. Data is inserted into the table from remote clients through a HTML form. The server-side app is PHP/FastCGI. The problem is that sometimes I get double entries into the table from one post. The AUTO_INCREMENT column increments correctly, but it duplicates the data and creates two rows in the table. This seems to only be occurring when the remote client is using a firewall. If the client turns off their firewall, the duplicate entries stop.

The AUTO_INCREMENT item is a bigint(18) unsigned. It functions as the primary key and is the only index in the table.

I've had this problem across several different versions of PHP and MySQL. Has anyone had a similar experience?

Thanks!
Reply With Quote
  #2 (permalink)  
Old 2004-06-25, 04:26 PM
Xnuiem's Avatar
Senior Member
 
Join Date: May 2004
Location: DFW, Texas
Posts: 1,104
Xnuiem will become famous soon enough
Send a message via Yahoo to Xnuiem
Default

I dont think this is a MySQL issue, but an application issue. I have seen this in some places before with an Image Gallery app a few months ago.
__________________
I rarely give code examples.
No, I have never used IIS or Windows of any kind as a web server. Get a real OS!
Please don't PM me, I won't respond.
Reply With Quote
Must read Review for Serious PHP Developers


NuSphere PhpED 5.0 : The Staff of php-editors.com recently spent a few days working with NuSphere PhpED 5.0 (a popular PHP IDE) and NuCoder 1.4 (a PHP Encoding Utility), read up on all the details.

Sponsored Links
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:22 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0
© Copyright 2003-2008 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.