title: MySQL doesn't update text field with textarea
body: <p>I want to update a text field in my mysql database but it doesn't change when I run the query. I've tried stripping special characters but it still doesn't work.</p>
  
  <p>UPDATE: It returns the following error: It gives the following error:</p>
  
  <blockquote>
    <p>You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use
    near 'datatext='LET OP! Aantal Mate' at line 1</p>
  </blockquote>
  
  <p>Here is the data:</p>
  
  <p>The HTML</p>
  
  <pre><code>&lt;form method="post" action="&lt;?php echo $_SERVER['PHP_SELF'];?&gt;"&gt;
  &lt;input type="hidden" name="nr" value="1"&gt;
  &lt;textarea rows="20" cols="50" name="text"&gt;&lt;/textarea&gt;
  &lt;/form&gt;
  </code></pre>
  
  <p>The PHP</p>
  
  <pre><code>$change_text = $_POST['text'];
  $change_nr = $_POST['nr'];
  if ((!empty($change_text))&amp;&amp;(!empty($change_nr)))
  {
  mysql_query("UPDATE table SET datatext='$change_text' WHERE datanr='$change_nr'");
  }
  </code></pre>
  
  <p>Structure MySQL (tablename = table)</p>
  
  <pre><code>datanr = int(6)
  order = text utf8_general_ci
  </code></pre>