update table set turns = turns+ x; update table set turns = max where turns > max; commit; #### update table set last_login = sysdate(), turns_left = ( $turns_per_day * datediff( sysdate(), last_login )) where user_id = ? #### update table set turns_left = ( $turns_per_day * datediff( sysdate(), last_login )), last_login = sysdate() where user_id = ?