#I LOVE YOU EVERDAY#

<?php
// get_Party Names.php
include_once('config.php');

if(!empty($_POST["selected_option"])){
    // Get country ID from the POST request
    $selected_option = $_POST['selected_option'];
	if($selected_option == 1)
	{
    // Fetch all Party Name data related to the specific country ID
    $query = "SELECT * FROM rent ORDER BY name ASC";
    $result = mysqli_query($con, $query);

// Generate HTML for the Party Name options
    echo '<option value="">Select Party Name</option>';
    while($row = mysqli_fetch_assoc($result)){
        echo '<option value="'.$row['reid'].'">'.$row['name'].'</option>';
    }
	}else if($selected_option == 2)
	{
    // Fetch all Party Name data related to the specific country ID
    $query = "SELECT * FROM advanced ORDER BY name ASC";
    $result = mysqli_query($con, $query);

// Generate HTML for the Party Name options
    echo '<option value="">Select Party Name</option>';
    while($row = mysqli_fetch_assoc($result)){
        echo '<option value="'.$row['adid'].'">'.$row['name'].'</option>';
    }
	}else if($selected_option == 3)
	{
    // Fetch all Party Name data related to the specific country ID
    $query = "SELECT * FROM advance_receive ORDER BY name ASC";
    $result = mysqli_query($con, $query);

// Generate HTML for the Party Name options
    echo '<option value="">Select Party Name</option>';
    while($row = mysqli_fetch_assoc($result)){
        echo '<option value="'.$row['adrid'].'">'.$row['name'].'</option>';
    }
	}else if($selected_option == 6)
	{
    // Fetch all Party Name data related to the specific country ID
    $query = "SELECT * FROM labour ORDER BY name ASC";
    $result = mysqli_query($con, $query);

// Generate HTML for the Party Name options
    echo '<option value="">Select Party Name</option>';
    while($row = mysqli_fetch_assoc($result)){
        echo '<option value="'.$row['lid'].'">'.$row['name'].'</option>';
    }
	}else if($selected_option == 7)
	{
    // Fetch all Party Name data related to the specific country ID
    $query = "SELECT * FROM suppliers ORDER BY name ASC";
    $result = mysqli_query($con, $query);

// Generate HTML for the Party Name options
    echo '<option value="">Select Party Name</option>';
    while($row = mysqli_fetch_assoc($result)){
        echo '<option value="'.$row['sid'].'">'.$row['name'].'</option>';
    }
	}else if($selected_option == 9)
	{
    // Fetch all Party Name data related to the specific country ID
    $query = "SELECT * FROM agent ORDER BY name ASC";
    $result = mysqli_query($con, $query);

// Generate HTML for the Party Name options
    echo '<option value="">Select Party Name</option>';
    while($row = mysqli_fetch_assoc($result)){
        echo '<option value="'.$row['aid'].'">'.$row['name'].'</option>';
    }
	}else if($selected_option == 11)
	{
    // Fetch all Party Name data related to the specific country ID
    $query = "SELECT * FROM expenses_type ORDER BY expenses ASC";
    $result = mysqli_query($con, $query);

// Generate HTML for the Party Name options
    echo '<option value="">Select Expenses Name</option>';
    while($row = mysqli_fetch_assoc($result)){
        echo '<option value="'.$row['exid'].'">'.$row['expenses'].'</option>';
    }
	}
}
?>