TEENFRONT Posted December 11, 2008 Share Posted December 11, 2008 Hey Right now im trying to simply "Add 1" to a mysql row value.. But im sure im going the long way round... right now im having to query to the DB get the number from a row then $row[num]++ , Then update the row with the new value... Is there a simple one line query to add a "1" as in "plus 1" to a row value? ?Im sure iv seen it somewhere but for the life of me i cannot find it... Quote Link to comment https://forums.phpfreaks.com/topic/136504-solved-plus-1-to-mysql-value/ Share on other sites More sharing options...
Maq Posted December 11, 2008 Share Posted December 11, 2008 I don't understand what the problem is. SELECT $new_val = $row['field'] + 1; INSTERT $new_val Quote Link to comment https://forums.phpfreaks.com/topic/136504-solved-plus-1-to-mysql-value/#findComment-712512 Share on other sites More sharing options...
trq Posted December 11, 2008 Share Posted December 11, 2008 UPDATE tbl SET fld = fld+1 Quote Link to comment https://forums.phpfreaks.com/topic/136504-solved-plus-1-to-mysql-value/#findComment-712515 Share on other sites More sharing options...
Maq Posted December 11, 2008 Share Posted December 11, 2008 He wanted to update and I use SELECT/INSERT. Today's going to be a long day.... :-\ Quote Link to comment https://forums.phpfreaks.com/topic/136504-solved-plus-1-to-mysql-value/#findComment-712522 Share on other sites More sharing options...
TEENFRONT Posted December 11, 2008 Author Share Posted December 11, 2008 Thanks thorpe thats the one! I swear i tried that but it didnt work, must have got it wrong. Many thanks. To Maq. Yes i was just wanting one query instead of selecting, adding, then updating. This way, its just one nice query lol. Quote Link to comment https://forums.phpfreaks.com/topic/136504-solved-plus-1-to-mysql-value/#findComment-712543 Share on other sites More sharing options...
Maq Posted December 11, 2008 Share Posted December 11, 2008 To Maq. Yes i was just wanting one query instead of selecting, adding, then updating. This way, its just one nice query lol. Yeah I know, just ignore my post... :-X Quote Link to comment https://forums.phpfreaks.com/topic/136504-solved-plus-1-to-mysql-value/#findComment-712569 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.