INSERT adds two identical records.

[jscs99]

Can anybody help? I'm really new at this. Can anybody see why this code should add two identical records?

<?php
session_start();

if ($Submit == "Reset"):
header("Location: [url]);
session_unset();
session_destroy();
exit;
endif;
?>

<?php
$db = mysql_connect("localhost", "user", "password");
mysql_select_db("database",$db);

$sql = "INSERT INTO People (FirstName,LastName,eMail,Address1,Address2,City,State,PostalCode,Country,Phone,Fax,CellPhone) VALUES ('$FirstName','$LastName','$eMail','$Address1','$Address2','$City','$State','$PostalCode','$Country','$Phone','$Fax','$CellPhone')";

$result = mysql_query($sql);

if (@($sql)) {
echo("<P>Person added ...</P><a href=addPerson.html>Add Another ...</a>");
} else {
echo("<P>Error adding record: " .
mysql_error() . "</P>");
}

session_unset();
session_destroy();
?>

</body>

[Anon]

It is inserting two rows because you are running the $sql statement twice. Once when you set $result, and once in the if statement. Since an insert does not return a record set, there is no need for the first one. Get rid of:

$result = mysql_query($sql);

and you should be fine.