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... 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 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 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.... :-\ 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. 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 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
Archived
This topic is now archived and is closed to further replies.