<?php 

session_start();

 include("includes/database.php");

  $select_query = "select * from member where get_addree='0'";

       $run = mysqli_query($con,$select_query); 

       while ($row = mysqli_fetch_array($run)) { 

        $member_id = $row['member_id'];

        $profile = $row['profile'];

        $title = $row['title'];

        $dob = $row['dob'];

        $name = $row['name'];

        $co_name = $row['co_name'];

        $gender = $row['gender'];

        $address_1 = $row['address_1'];

        $address_2 = $row['address_2'];

        $town_area = $row['town_area'];

        $city_district = $row['city_district'];

        $state = $row['state'];

        $country = $row['country'];

        $pincode = $row['pincode'];

        $mobile_number = $row['mobile_number'];

        $email = $row['email'];

        $aadhaar_card = $row['aadhaar_card'];

        $pan_card = $row['pan_card'];

        $nominee_name = $row['nominee_name'];

        $nominee_relationship = $row['nominee_relationship'];

        $nominee_contact = $row['nominee_contact'];

        $account_name = $row['account_name'];

        $account_number = $row['account_number'];

        $ifsc_code = $row['ifsc_code'];

        $bank_name = $row['bank_name'];

        $branch_name = $row['branch_name'];



        $member_no = $row['member_no'];

        $user_id = $row['user_id'];

        $password = $row['password'];

        $elite_board = $row['elite_board'];



        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];



        $member_fess = $row['member_fess'];

        $activity_level = $row['activity_level'];

        $activity_referral = $row['activity_referral'];

        $activity_date = $row['activity_date'];

        $activity_month = $row['activity_month'];



        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];

        $date_of_join =$row['date_of_join'];

        $update_member =$row['update_member'];

        $profile = $row['profile']; 

         $address_1_f = $row['address_1_f'];

         $address_2_f = $row['address_2_f']; 

         $city_district_f = $row['city_district_f'];

         $state_f = $row['state_f']; 

         $pincode_f = $row['pincode_f'];

         $mobile_number_f = $row['mobile_number_f'];
         
         
         $insert_querys = "insert into delivery_address(name, member_no, address_1_f, address_2_f, town_area_f, city_district_f, state_f, country_f, pincode_f, mobile_number_f) values('$name', '$member_no', '$address_1', '$address_2', '$town_area', '$city_district', '$state', '$country', '$pincode', '$mobile_number')";

           mysqli_query($con,$insert_querys);
         
         
           $insert_query = "insert into delivery_address(name, member_no, address_1_f, address_2_f, town_area_f, city_district_f, state_f, country_f, pincode_f, mobile_number_f) values('$name', '$member_no', '$address_1_f', '$address_2_f', '$town_area_f', '$city_district_f', '$state_f', '$country_f', '$pincode_f', '$mobile_number_f')";

           mysqli_query($con,$insert_query); 
           
           
           
           
          mysqli_query($con,"update member set get_addree='1' where member_no='$member_no'"); 
         
         
       }

   

    

  ?>