title: PHP PDO update prepared statement
body: <p>I'm trying to update my database with the following query:</p>
  
  <pre><code>$sth = "UPDATE rpacks SET rpacks_location VALUES (:location) WHERE rpacks_id = (:id)";
  $q = $conn-&gt;prepare($sth);
  $q-&gt;execute(array(':location'=&gt;$location, ':id'=&gt;$id));
  </code></pre>
  
  <p><b>But I'm getting this error</b></p>
  
  <p><code>Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax     error or access violation: 1064 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 'VALUES ('test') WHERE rpacks_id = ('2')' at line 1' in</code></p>