Adding 1 to a number in a database

[alexville]

Hello,

I am making a php script. And I need help. I want to run a query where it grabs a number from the database then adds 1 to it. Could someone run me though this?

[toplay]

For incrementing and updating the row:
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']UPDATE[/span] table_name SET column_name [color=orange]=[/color] column_name [color=orange]+[/color] 1 [color=green]WHERE[/color] some_column [color=orange]=[/color] [color=red]'something'[/color]
[!--sql2--][/div][!--sql3--]

For just selecting data and incrementing that value without updating existing row:
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] column_name [color=orange]+[/color] 1 [color=green]AS[/color] incremented_value [color=green]FROM[/color] [color=orange]table_name[/color] [color=green]WHERE[/color] some_column [color=orange]=[/color] [color=red]'something'[/color]
[!--sql2--][/div][!--sql3--]