<?php include"include/cookie.php"; ?>
<?php
if(isset($_POST["category"]) && !empty($_POST["category"])){
    $d=$_POST['category'];
    //echo "<script>alert($d);</script>";
    $query = mysqli_query($db,"SELECT * FROM subcategory_data WHERE Cid = '$d'");
    $rowCount = mysqli_num_rows($query);
   // echo "<script>alert($rowCount);</script>";
    if($rowCount>0){
        echo '<option value="">Choose subcategory</option>';
        while($row = mysqli_fetch_assoc($query)){ 
            $id=$row['Id'];
            //echo "<script>alert($id);</script>";
            $name=$row['SubCategory']; ?>
            <option value="<?php echo $id; ?>"><?php echo $name; ?></option>
       <?php  }
    }else{
        echo '<option value="">subcategory not available</option>';
    }
}
?>