Help for this page

Select Code to Download


  1. or download this
      update table set turns = turns+ x;
      update table set turns = max where turns > max;
      commit;
    
  2. or download this
      update table set
        last_login = sysdate(),
        turns_left = ( $turns_per_day * datediff( sysdate(), last_login ))
      where user_id = ?
    
  3. or download this
      update table set
        turns_left = ( $turns_per_day * datediff( sysdate(), last_login ))
    +,
        last_login = sysdate()
      where user_id = ?