Build a Newsletter System With PHP and MySQL: New Premium Tut

Jenny : I had the same problem but now it works ! Alex send me the answer.

In the “messages_edit.php” page, juste replace your code by this one and it will work :

// Check for a POST
if(isset($_POST['submitted'])) {
$link = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die(‘There was a problem connecting to the database.’);
if($template[0]['columns'] == “1″) {
$body = mysqli_real_escape_string($link, $_POST['body']);
$sql = “UPDATE messages SET subject=’”.$_POST['subject'].”‘, leftcol=’$body’, template_id=”.$_POST['template'].” WHERE id=$id”;
} else {
$leftcol = mysqli_real_escape_string($link, $_POST['leftcol']);
$rightcol = htmlentities($_POST['rightcol']);
$sql = “UPDATE messages SET subject=’”.$_POST['subject'].”‘, leftcol=’$leftcol’, rightcol=’$rightcol’, template_id=”.$_POST['template'].” WHERE id=$id”;
}
$stmt = $link->query($sql) or die($link->error);
$stmt->close;
$_SESSION['success'] = “Edited message.”;
header(‘Location: messages.php’);
}