<?php

include("connection.php");

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

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