[RESOLVED] MySQL INSERT doubles values

[foreach]

Hello,

im very new in the php and mysql world, so i have a problem with the sql database.
i have a form.php:

<form method="post" action="answer.php">
<input type="radio" name="sugu" value="yes" />
<input type="radio" name="sugu" value="no"  />
</form>

and answer.php:

$con = mysql_connect("**********.com","****","***");
if (!$con) {	die('err: '. mysql_error()); }
else { echo 'ahhaaa'; }
mysql_select_db("dbbbb",$con);
$sql = 
"
INSERT INTO vastused(sugu) 
VALUES ('$_POST[sugu]')
";
mysql_query($sql,$con);
if (!mysql_query($sql,$con))
{
echo 'ei, Error:'.'<br/>'.mysql_error();
}
mysql_close($con);/*

code inserts the answer twice into to the table. What am i doing wrong or what should i add?

[johanafm]

You execute the query twice...

# execute query once
mysql_query($sql,$con);
# execute query again...
if (!mysql_query($sql,$con))

[foreach]

edited it to
$add=mysql_query($sql,$con);
if (!$add)
and now it is working, Thank you 🙂

[DaveRandom]

You could just lose the first query from the original code, and not waste (albeit a very small amount) extra memory on an unnessecary variable.

[foreach]

Yeah though that too after posting, but since im just learning this stuff i didnt bothered to edit my post, but thanks for your reply. 🙂