<?php

include("connection.php");

if (isset($_POST['c_id'])) {
	$c_id = $_POST['c_id'];
	$sql = "select * from `checklist` where `country`='$c_id' order by id desc";
	$res = mysqli_query($con, $sql);
	if (mysqli_num_rows($res) > 0) {
?>
		<option value=''>Select Purpose</option>
		<?php

		while ($r = mysqli_fetch_array($res)) {
			$country_id = $r['purpose'];
		
		?>
			<option value="<?php echo $country_id ?>"><?php echo $country_id ?></option>
<?php
		}
	}
} else {
	header('location: visa-checklist.php');
}