<?php 

session_start();

 $con = mysqli_connect("localhost","rakchatest","rakchatest@12345","rakchatest");



// Check connection

if (mysqli_connect_errno())

  {

  echo "Failed to connect to MySQL: " . mysqli_connect_error();

  }

 

 

        $select_query_main = "select * from roi_tree ORDER BY tree_id ASC";

        $run_main = mysqli_query($con,$select_query_main);

         

         while ($row_main = mysqli_fetch_array($run_main)) {

          

          $tree_id_main = $row_main['tree_id'];

          $member_no_main = $row_main['member_no'];

          $user_id_main = $row_main['user_id'];

          $sponsor_no_main = $row_main['sponsor_no'];

          $relation_ship_no_main = $row_main['relation_ship_no'];

          $level_no_main = $row_main['level_no'];

          $x_position_main = $row_main['x_position']+1;

          $y_position_main = $row_main['y_position'];

          $roi_amount_main = $row_main['roi_amount'];

          $roi_status_main = $row_main['roi_status'];

          $status_main = $row_main['status'];

          $product_amount_main = $row_main['product_amount'];

          $total_bv_main = $row_main['total_bv'];



           

          





          mysqli_query($con,"update wallet_payout set user_id='$user_id_main' where member_no = '$member_no_main'");



           





                                } 



    

  ?>