<?php 



  include("includes/database.php");



   $member_no = "008";



   $date = "2022-08-01";



       $select_query_main_2 = "select * from roi_tree where member_no = '$member_no'";

          $run_main_2 = mysqli_query($con,$select_query_main_2);

          $check_level_2 = mysqli_num_rows($run_main_2);

          while ($row_main_2 = mysqli_fetch_array($run_main_2)) {

          $tree_id_main_2 = $row_main_2['tree_id'];

          $group_number_main_2 = $row_main_2['group_number'];

          $member_no_main_2 = $row_main_2['member_no'];

          $sponsor_no_main_2 = $row_main_2['sponsor_no'];

          $level_no_main_2 = $row_main_2['level_no'];

          $relation_ship_no_main_2 = $row_main_2['relation_ship_no'];

          $x_position_main_2 = $row_main_2['x_position'];

        }





        $select_query_per_product_x1_10a = "select SUM(network_amount) from percent_member where relation_ship_no LIKE '%{$relation_ship_no_main_2}%' AND date='$date'";

          $run_per_product_x1_10a = mysqli_query($con,$select_query_per_product_x1_10a);

          while($row_per_product_x1_10a = mysqli_fetch_array($run_per_product_x1_10a)){

                $p_per_product_x1_10a = $row_per_product_x1_10a['SUM(network_amount)'];

          }



          echo $p_per_product_x1_10a;





 ?>