[RESOLVED] double records in MySQL

[shanba_kay]

Hi!

I have a form that uses an image instead of the submit button.
Looks like this:

			
			<!--Next-->
			<br/>
			<p>Please click <b>NEXT</b> to continue.</p>
			<br/>
			<p style="text-align:right;">
				<input type="image" src="JPG/next.jpg" alt="submit and go to next page"/>
			</p>
		</form>		 

The form action is set to "theNextPage.php".
Everything works fine, except when I check the database after submission, I see two records instead of one (that is the new record is doubled).

I was looking at disabling the button after it has been clicked, but that should really be a problem, should it, since on click they go to the next page anyway...

Any ideas?
Thanks.

[bradgrafelman]

It might be that the users are double clicking the button, or clicking it again impatiently before the next page loads.

Have you tried entering data into the form yourself and clicking the image once? Does it still insert two rows into the DB?

[shanba_kay]

Yeah, the error was in the php code.
I had the mysql_query(bla bla) sent twice to the server, onec when I calculated var $sql and once when I checked to see if the query had gone through.

I was doing this:

if (!mysql_query(bla bla)) die(bla bla)

instead of

if (!$sql) die (bla bla)

Good point to remember, the mysql_query() contacts the server every time it appears in the code. Guess it makes sense 🙂

M