<?php

include "general.php";
include "connect.php";


$sn = isset($_GET['err']) ? $_GET['err'] : '';

$query ="select * from penpalsubscriberamerica where sn=$sn ";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  //echo "Database error please try again";
  //var_dump( mysqli_error($con));
  //echo "me";
   mysqli_close($con);
   header('Location: unsubconfirmed.php?err=2');
     die();

}


while($row = mysqli_fetch_array($result))
{

$query = "update penpalsubscriberamerica set emailreceived ='1' where sn =$sn";
$queryresponse = updateQuery($query);
//echo $query;

if ($queryresponse=="0" ){

 header('Location: unsubconfirmed.php?err=0');
   die();

}
else
{

   header('Location: unsubconfirmed.php?err=1');
   die();
}

}// end of while 

?>