Thank you both for your responces. Unfotuantely there is no form that instantiates this action. So the double submit (while a good idea), is not possible. As for some sample code, it is part of a rather complicated system that makes a number of changes but essentailly what is going on is this: 1. Grab all items that we need to do some shipping stuff to. 2. Foreach through the items, giving each item number to a function to assign it to a customer and create a mailling label. That simple! The interesting this is this - the duplicate record is inserted into the mailing labels queue. I can see it long before I grab the data for output to labels. Moreover, I can tell that the problem isn't in the original item select statement because the function (executed for each item) would have created different insert times in the database based on the now( ). More ideas? Thanks! "Jed R. Brubaker" <jrb21398@xxxxxxxxxxx> wrote in message news:20050301170618.7916.qmail@xxxxxxxxxxxxxxxx > Hi all - > > I could use a lead on a problem. I just don't know where to start. > > I have a PHP script that populates a database table. No big deal. It > creates mailing labels. However, a weird things keeps happening - every > once in a while, a query is run twice. It is the same query, same > information, even the same time (there is a now() in the query - and it is > identical). > > So the question is a simple one - is this a PHP problem or a MySQL > problem? Or somewhere in the MySQL extension? And how would I know? > > There is one clue to this otherwise vague problem. I believe that this > predominantly happens when the database is under an above average load. > > I would appreciate any help that I might be able to get. > > Thank you. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
