quick ? about UPDATE

[xcandiottix]

I'm looking to take a number in column A of my table and increase it by one when a button is pressed. I tried using UPDATE in dreamweaver but the text doest change color as if it is a recognized line of code. Also, when I upload to the server the code just doesn't seem to do anything. Any thoughts?

[xcandiottix]

yeah.... nevermind. 

 

Here's working update code incase someone needs it:

mysql_query("UPDATE tablename SET columnname = 'whatever'

WHERE columnname2 = 'however'");

 

Table tablename will look in column columnname2 for however ... anywhere it finds however it will replace the value of column columnname to whatever.