|
|
Posted by Jed R. Brubaker on 03/04/05 07:42
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@hotmail.com> wrote in message
news:20050301170618.7916.qmail@lists.php.net...
> 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.
Navigation:
[Reply to this message]
|