Discussion 85 Comments

1. flo says:

   December 14, 2010 at 12:54 am

   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’);
   }

   Reply
2. Celio says:

   December 26, 2010 at 3:24 pm

   Hi there!
   This is such a nice tut, really worth the $9 fee, but I’m having lots of problems trying to get it done. So far i am about to start on the step 7 – subscribers, however I can’t get the template preview working at all. When i click on binoculars icon it won’t preview the template like on the screencast.

   Help, please!!
   Thanks

   Reply