[SOLVED] Inserts data twice

[peranha]

I have the following code on a page, and this is inserting data twice to the sql database, and I cannot figure out why.  If I execute it in myadmin, it only inserts 1.

 

<?php

//  Create query and execute query.
$bquery = mysql_query("INSERT INTO " . $pregm . "positions (position_1, position_2, position_3) VALUES ('{$position1}', '{$position2}', '{$position3}')");

//  redirect back to the index page.
header ("Location: index.php");

exit();
?>

[waynew]

Are you sure that it's inserting it twice?

[rhodesa]

There is no reason the code you posted would insert twice. How are you calling the code? Is a page submitting to it?

[peranha]

Are you sure that it's inserting it twice?

 

Positive it is

 

There is no reason the code you posted would insert twice. How are you calling the code? Is a page submitting to it?

 

I am calling if from a hyperlink.  That is the complete page, minus the database connection, and selecting the database.

[waynew]

All I can say is that something else in your application is causing it to happen.

[rhodesa]

if you comment out the header() line, and just do an

echo "DONE";

does it still enter twice?

[peranha]

Yes it does, it is something with the hyperlink that is causing it to happen, if I call the page directly, it only inserts once. 

[PFMaBiSmAd]

Your browser is requesting the page twice. You need to add some logic to prevent the requests after the first one from executing the database query -

http://www.phpfreaks.com/forums/index.php/topic,226301.msg1043443.html#msg1043443

[DarkWater]

Moral of the story: Specify a charset for your page.

[peranha]

charset is set to utf-8

 

I will look into this.  Thanks.

 

Your browser is requesting the page twice. You need to add some logic to prevent the requests after the first one from executing the database query -

http://www.phpfreaks.com/forums/index.php/topic,226301.msg1043443.html#msg1043443

[awpti]

I bet you have Firebug.

 

Turn it off.

[peranha]

Nope, no firebug

[Prismatic]

Are you double clicking your links?

[PFMaBiSmAd]

There are several reasons a page can get requested twice - browsers, url rewriting, javascript form submission...

 

The fix is to detect multiple page requests and ignore all but the first one.

 

The code in the first post is not even doing the minimum validation needed to prevent a search engine indexing the site from inserting empty records.