title: mysql_query update value 2 by 2
body: <p>when i run the below mysql query in mysql front end the value increase by one:</p>
  
  <p>Query: <code>update tableName set ColA=ColA+1</code></p>
  
  <pre><code>previous value: 12
  value after running query(1st time): 13
  value after running query(2nd time): 14
  </code></pre>
  
  <p>But when i run the same query through my php script then it's always update 2 by 2.</p>
  
  <pre><code>&lt;?php
  mysql_query("update tableName  set ColA=ColA+1",$conn); 
  ?&gt;
  
  previous value: 12
  value after running query(1st time): 14
  value after running query(2nd Time): 16
  value after running query(3rd Time): 18
  </code></pre>
  
  <p>why it's happening?</p>
  
  <pre><code>PHP Version 5.4.24
  Mysql Version: 5.5.14
  IIS version: 7
  </code></pre>