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