title: PDO SQL Query Error in Where Clause
body: <p>Hello Im getting the following error when trying to update my database: </p>
  
  <blockquote>
    <p>Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column ''1'' in 'where clause''</p>
  </blockquote>
  
  <p>Im getting three variables via POST They are: </p>
  
  <p>a) the Column I want to change </p>
  
  <p>b) The new value for the column</p>
  
  <p>c) the ID which row to change...</p>
  
  <p>Im using PDO, this is my Query with param-binding and execution:</p>
  
  <pre><code>$stmt = $db-&gt;prepare('UPDATE `artists` SET `:spalte` = `:wert` WHERE  `id` = `:pk` ');
  $stmt-&gt;bindParam(':spalte', $name);
  $stmt-&gt;bindParam(':wert', $value);
  $stmt-&gt;bindParam(':pk', $pk);
  $stmt-&gt;execute();
  </code></pre>
  
  <p>I hope someone will understand this error...</p>
  
  <p>Best Regards</p>
  
  <p>Dave</p>