Re: mysql problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux