Re: Re: mysql problems

Jed R. Brubaker wrote: > 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( ). Show us code excerpts. We can't second-guess from your description, as good as it is. Pin-point the code that is doing the double insert, and print out some debugging info there. -- Like Music? http://l-i-e.com/artists.htm