Increment DB Column Value using HTML Form

[WilliamMute007]

Hi,

Me again.. can anyone please advice how I can increment the value in my DB table. Say for example, Add 2 to the number of user so if number of user was 100 before, it will now be 102. (using a HTML form)

("UPDATE tablename SET column = column ++ 2 WHERE column ID = $var"); ???

And where I need to update multiple columns how can I go about that? Say increment column 1 +1 Column 2 + 1 Column 3 + 1 etc...


Would it be something like that?

 

[jpadie]

this is more a mysql question. you might be better off asking in that forum.

but this should work

update tablename set column=column + 2, column2=column2 + 3 where anothercolumn=$variable

 

[WilliamMute007]

Thanks Justin.. I havent tried it yet but will do at some point this evening. Am just thinking ahead of myself. Thanks tho. Will let you know if it works!