query($query);
// Generate HTML of state options list
if($result->num_rows > 0){
echo '';
while($row = $result->fetch_assoc()){
echo '';
}
}else{
echo '';
}
}elseif(!empty($_POST["state_id"])){
// Fetch city data based on the specific state
$query = "SELECT * FROM cities WHERE state_id = ".$_POST['state_id']." AND status = 1 ORDER BY city_name ASC";
$result = $con->query($query);
// Generate HTML of city options list
if($result->num_rows > 0){
echo '';
while($row = $result->fetch_assoc()){
echo '';
}
}else{
echo '';
}
}
?>