Hi.
I have a form which submits to a script which then puts the data in a database. Most of the time it works fine, but there have been a number of times, maybe once a day, that it seems to get stuck and the same person enters the same data many times.
I used to put this down to people keep clicking the submit button if it was loading slowly, however, the button now disapears when it is clicked on, and a friend tried tested it the other day and he says he only clicked it once and it submitted multiple times.
I did not make the form, but did make the submission script. There is no reason why the submission script would make multiple entries in the database, there are no loops etc, just a query. This suggests the submission script has been conneced to repeatedly.
If I take a look at the times of the most recent (HH:MM:SS), you can see what I mean. My thoughts are that the first was submitted, then re-submitted for the second 3, then resubmitted again for the final 3.
19:56:37
20:06:28
20:06:31
20:06:32
20:07:11
20:07:14
20:07:18
If they were entered by a bug in my script, I would also have expected them to be much closer together, i.e. within the second... but I know there is no bug anyway.
This then leads me to the form. I didnt make it, but get the general idea of how it works. It submits to itself, does some validation, then either displays the form again or creates a hidden form, with; <body onload=document.hidden_form.submit();> to submit it.
I dont have a clue where to start to debug this problem, the code is fine, and works most of the time. Where else could the problem lay to cause multiple connections? proxy maybe?
Thank you for any info!
K.