Unanswered: update cur_points with cur_points+points, then wipe points (was "Help needed please")
Greetings everyone, I'm posting this thread with the hope that someone will notice it and might offer me a helping hand regarding one of my problems.
I have the database named "DBEXAMPLE" with the table MEMB_INFO that contains two important columns that are named cur_points and points where cur_points column contains the total available points that a member can use/spend on a game and the points column stores the total of the points that a member used so far.
So as i plan to wipe all data of the database, i need to keep the member login,password and total points that each member purchased.
So i will somehow need to update the cur_points column with the total of current cur_points+points columns and then wipe points column.
I've personally asked a friend regarding this and he said that this should be something complicated and it might require php also.
Really appreciate if someone could help me regarding this.
Column cur_points -> total available points that a member can spend
Column points -> total points that the member has already spent
Column memb___id -> member login aka account id
TODO -> update cur_points column with the total of cur_points+points columns for each member(buyer)