hno Posted May 27, 2009 Share Posted May 27, 2009 HI I want a query that add 1 to the value that the query has been retrieve from the database.In the other hands a=a+1 and then update that field. thanks Quote Link to comment https://forums.phpfreaks.com/topic/159846-how-to-write-this-query/ Share on other sites More sharing options...
Maq Posted May 27, 2009 Share Posted May 27, 2009 HI I want a query that add 1 to the value that the query has been retrieve from the database.In the other hands a=a+1 and then update that field. thanks I'm having difficulty understanding you. Do you want to add 1 to a field? UPDATE table SET field = field + 1 Or, do you want to add one to field 'a' and assign it to field 'b'? Quote Link to comment https://forums.phpfreaks.com/topic/159846-how-to-write-this-query/#findComment-843066 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.