<?php // get_Flatss.php include_once('config.php'); if(!empty($_POST["selected_option"])){ // Get country ID from the POST request $selected_option = $_POST['selected_option']; // Fetch all Flats data related to the specific country ID $query = "SELECT * FROM flat_master WHERE project_no = '$selected_option' ORDER BY flat_no ASC"; $result = mysqli_query($con, $query); // Generate HTML for the Flats options echo '<option value="">Select Flat No.</option>'; while($row = mysqli_fetch_assoc($result)){ echo '<option value="'.$row['flid'].'">'.$row['flat_no'].'</option>'; } } ?>