title: MySQL - adding 1 to column with name in backticks
body: <p>I'm having trouble adding 1 to a column value in MySQL.  I've used backticks on the column name and value isn't incrementing.  Here is my query:</p>
  
  <pre><code>$update = $connectdb-&gt;prepare("UPDATE `strings` SET posted=posted, `response-comment`=`response-comment` + 1 WHERE `id`=?");
  $update-&gt;execute(array($id));   
  </code></pre>
  
  <p>Why isn't my query working?  The value <code>$id</code> is correct, the column <code>response-comment</code> should increase by 1.</p>