shaggycap Posted May 11, 2006 Share Posted May 11, 2006 I have a table that I want to update a counter field. However I dont want to use update as it will replace the value, I want to add the new value onto the existing, to increment the value by that amount.Can I do this with an update statement? or will I have to pull the exisiting value out first and add them up in my code? Just thought there may be a function to do this, as it seems quite a common task.Thanks Link to comment https://forums.phpfreaks.com/topic/9539-adding-to-a-counter-value-in-a-db/ Share on other sites More sharing options...
ryanlwh Posted May 12, 2006 Share Posted May 12, 2006 [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']UPDATE[/span] table SET field[color=orange]=[/color]field[color=orange]+[/color]$new_value [color=green]WHERE[/color] condition [!--sql2--][/div][!--sql3--] Link to comment https://forums.phpfreaks.com/topic/9539-adding-to-a-counter-value-in-a-db/#findComment-35295 Share on other sites More sharing options...
shaggycap Posted May 13, 2006 Author Share Posted May 13, 2006 [!--quoteo(post=373320:date=May 12 2006, 04:07 PM:name=ryanlwh)--][div class=\'quotetop\']QUOTE(ryanlwh @ May 12 2006, 04:07 PM) [snapback]373320[/snapback][/div][div class=\'quotemain\'][!--quotec--][!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']UPDATE[/span] table SET field[color=orange]=[/color]field[color=orange]+[/color]$new_value [color=green]WHERE[/color] condition [!--sql2--][/div][!--sql3--][/quote]Great stuff, thank you ryanlwh [img src=\"style_emoticons/[#EMO_DIR#]/wink.gif\" style=\"vertical-align:middle\" emoid=\":wink:\" border=\"0\" alt=\"wink.gif\" /] Link to comment https://forums.phpfreaks.com/topic/9539-adding-to-a-counter-value-in-a-db/#findComment-35507 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.