Increment a value in MySQL with PHP/MySQL?
<p>I have a posting system. When the user posts, I want the postcount row in the table to increase by one. I have researched on Google and I have only found this.</p>

<pre><code>mysql_query("UPDATE users SET postcount=postcount+1 WHERE username = '$username'");
</code></pre>

<p>I have also tried it with spaces </p>

<pre><code>mysql_query("UPDATE users SET postcount = postcount + 1 WHERE username = '$username'");
</code></pre>

<p>And no such luck, I'm not seeing the number in the table increasing. 
Help?
Thanks!</p>
