Double Insert Problem

[hicksman]

I am currently working on an application using php,mysql, and smarty templates. Two of the pages I am working on are doing very simple insert statements that look like this:

$comp_date = date("YmdHis");
$sql = "INSERT INTO comp (comp_date,firstname,lastname,vip_id,amount,pitboss_id,location_id) values ('".$comp_date."','".$firstname."','".$lastname."','".$vip_id."','".$POST["amount"]."','".$POST["pitboss_id"]."','".$_SESSION["location_id"]."')";
if ($conn->execute($sql))....

When the insert is done, it is inserting two records in the table for some unknown reason. A dump of the table looks like this:

CREATE TABLE comp (
comp_id int(11) NOT NULL auto_increment,
comp_date varchar(20) NOT NULL default '',
firstname varchar(50) NOT NULL default '',
lastname varchar(50) NOT NULL default '',
vip_id int(11) NOT NULL default '0',
amount float(4,2) NOT NULL default '0.00',
pitboss_id int(11) NOT NULL default '0',
location_id int(11) NOT NULL default '0',
KEY comp_id (comp_id)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

Anyone have any idea of why it is inserting duplicate rows?

[DeltaRho2K]

Sorry, just changing your code aronud a bit here 😉 Try this out, and see if it works for you any better.

// Set the variables for the POST and SESSION values
$amount = $_POST['amount'];
$pitboss_id = $_POST['pitboss_id'];
$location_id = $_SESSION['location_id'];

// Change the SQL around a bit so you can avoid the whole escaping the quotes scenario.
$sql = "INSERT INTO comp (comp_id, comp_date, firstname, lastname, vip_id, amount, pitboss_id, location_id) values ('', '$comp_date', '$firstname', '$lastname', '$vip_id', '$amount', '$pitboss_id', '$location_id')"; 

[wisskid]

Most likely, the reason that the row is inserted twice, is since the php code is executed twice. You might want to put some

echo "INSERT ROW NOW!<br />";

statements here and there and see where they come up...