title: MYSQL syntax error 1064
body: <p>I just cant figure out why am getting error 1064 from this query</p>
  
  <pre><code>//prep the data for database use
  $manufacturer_id = $_GET['id'];
  $manufacturer_display_name = mysql_prep($_POST['manufacturer_display_name']);
  $manufacturer_name = mysql_prep($_POST['manufacturer_name']);
  
  
  $query = "UPDATE IT_manufacturer SET
          manufacturer_name = '{$manufacturer_name}',
          manufacturer_display_name = '{$manufacturer_display_name}',
          WHERE manufacturer_id = {$manufacturer_id}
          ";
  
  $result = mysql_query($query, $connection);
  confirm_query ($result);
  </code></pre>
  
  <p>If I echo the variables $manufacturer_name, $manufacturer_display_name, $manufacturer_id they all have values but am getting this error</p>
  
  <p>could not excecute queryYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE manufacturer_id = 1' at line 4 error number 1064</p>
  
  <p>Any help</p>