<?php

include("connection.php");

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

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