title: Textarea won't submit to MySQL with wysiwyg editor?
body: <p>I'm trying to format some texts from the textarea using a rich text editor.</p>
  
  <p>However, every time I hook up the editor to my textarea, the textarea doesn't submit it's data to MySQL database and it is frustrating to sat the least. </p>
  
  <p><strong>PHP code:</strong></p>
  
  <pre><code>if (isset($_POST['answer'])) {
  
      $id = mysqli_real_escape_string($db_conx, $_POST['id']);
      $answer = mysqli_real_escape_string($db_conx, $_POST['answer']);
  
      $stmt = mysqli_prepare(
          $db_conx,
          "INSERT INTO forum_answer(answer)VALUES(?)"
      );
      //after validation, of course
      mysqli_stmt_bind_param($stmt, "s", $answer);
      mysqli_stmt_execute($stmt);
      if (mysqli_affected_rows($db_conx))
      {
          mysqli_stmt_close($stmt);//&lt;-- CLEAN UP AFTER YOURSELF!
          //update was successful
      }
  }
  </code></pre>
  
  <p><strong>HTML:</strong></p>
  
  <pre><code>&lt;form name="form1" method="post" action="mypage.php"&gt;
      &lt;textarea class="rte-zone"  name="answer" cols="45" rows="3" id="answer"&gt;&lt;/textarea&gt;
  &lt;/form&gt;
  </code></pre>
  
  <p>Rich text editor that I am using: <a href="http://batiste.dosimple.ch/blog/posts/2007-09-11-1/" rel="nofollow">THIS IS THE RICH TEXT EDITOR</a> </p>
  
  <p>My PHP code works fine without the rich text editor and it will store the textarea data into the MySQL database fine but it will stop working as soon as I hook it up to the text editor.</p>
  
  <p>The main reason I need to use a text editor is to format the textarea texts before i enter them into the MySQL database so I can use the data in another HTML page format.</p>
  
  <p>Any help would be appreciated. </p>
  
  <p>Thanks in advance. </p>