Math in queries

[netfrugal]

I want to create an UPDATE statement that will either add or subtract by 1.

One of my columns has an integer value, and I want to be able to add or subtract the number found in that row.

It is for changing the sort orders on the web page for any row!

If this is not the best way of accomplishing my task, then I'd like to know.

Here is what I have so far:

$mysql = "UPDATE SET table(sort) 
                 VALUES(    'this is where I am not sure'    ) 
                 WHERE recID = '$_POST[recID]' ";

I know the VALUES section is where to handle how to update the data, but math in mysql queries are weird to me.

any ideas?

[tomhath]

update theTable set theColumn = theColumn + 1 where recID = whatever