[SOLVED] update +1

[merylvingien]

Am i right in thinking that this statement should increase the mailcount by 1

 

$sql = "UPDATE table SET mailcount = mailcount + 1 WHERE value=$value";

 

Its adding 2 for some reason?

[Daniel0]

You're probably executing the query twice. Try posting the code.

[merylvingien]

if (!isset($_POST['emailid'])) {echo 'There appears to be a problem, please go back and try again.'; exit;}
else
if (isset($_POST['emailid'])) {$emailid= $_POST['emailid'];}
$emailid= mysql_real_escape_string($emailid, $con);
$emailid= htmlspecialchars($emailid);

if (strlen($emailid) >5) {echo 'There appears to be a problem, please go back and try again.'; exit;}
else

$sql = ("SELECT * FROM postcode WHERE postcodeID='$emailid'")or die ('<p>There seems to be a problem, please try again.</p>');
$result = mysql_query($sql,$con);
$row = mysql_fetch_assoc($result);

$name = $_POST["name"];
$from = "[email protected]";
$contact = $_POST['contact'];
$message = $_POST["message"];

$verif_box = $_REQUEST["verif_box"];
$name = stripslashes($name);
$message = stripslashes($message); 
$from = stripslashes($from); 

if(md5($verif_box).'a4xn' == $_COOKIE['tntcon']){

$sql = "UPDATE postcode SET mailcount = mailcount + 1 WHERE postcodeID=$emailid";
      mysql_query($sql) or trigger_error('<p>There seems to be a problem, please try again soon.</p>');
      $result = mysql_query($sql);
mail("{$row['email']}", 'some message ', "\n $name just sent you a message  \n Their email address is: $contact  \n Their message is: $message  " , "From: $from" );

setcookie('tntcon','');
} else {
// if verification code was incorrect then return to contact page and show error
header("Location:".$_SERVER['HTTP_REFERER']."?subject=$subject&from=$from&message=$message&wrong_code=true");
exit;
}
?>

[Daniel0]

Right, you are actually calling it twice:

 

   $sql = "UPDATE postcode SET mailcount = mailcount + 1 WHERE postcodeID=$emailid";
      mysql_query($sql) or trigger_error('<p>There seems to be a problem, please try again soon.</p>');
      $result = mysql_query($sql);

 

Of course it'll update twice when you call it twice.

[merylvingien]

Doh!!!!!!! 

 

Ok once again i get the idots cap for the evening.

I must be up for a tee shirt by now