title: Using PDO Prepared Statement and Incrementing a column value
body: <p>I've read this thread: <a href="https://stackoverflow.com/questions/7835024/issues-incrementing-a-field-in-mysql-php-with-prepared-statements">Issues incrementing a field in MySQL/PHP with prepared statements</a> but didn't see the answer to my problem. </p>
  
  <pre><code>PDOStatement Object
  (
  
      [queryString] =&gt; UPDATE user_alerts SET notif = ? + 2 WHERE ( user_id = ? )   
  
  )
  
  $stmt-&gt;execute( array( 'notif', '1' ) );
  </code></pre>
  
  <p>As far as I can tell, all this is correct.  </p>
  
  <p>When the above code executes, it sets the notif column equal to 2 irregardless of what the value of the notif column is.  It's as if the SQL is reading like <code>SET notif = 2</code> instead of <code>SET notif = notif + 2</code></p>
  
  <p>I haven't been able to figure it out and would really appreciate help!</p>