pro_list.php

<?php
require 'config.php';
$conn = connection();
$sql = "SELECT * FROM product p inner join category c on c.cat_id=p.pro_grpid inner join type t on t.ty_id=p.pro_typeid inner join firm f on f.firm_id=p.pro_firmid
ORDER BY cat_name ASC ";
$data = $conn->query($sql);
$cat_dat = "SELECT * FROM category order by cat_name ASC";
$cat_dat = $conn->query($cat_dat);
$cat_dat1 = "SELECT * FROM category order by cat_name ASC";
$cat_dat1 = $conn->query($cat_dat1);
$firm_data = "SELECT * FROM firm order by firm_name ASC";
$firm_data = $conn->query($firm_data);
$firm_data1 = "SELECT * FROM firm order by firm_name ASC";
$firm_data1 = $conn->query($firm_data1);
$conn=null;

?>

<!--   <div class="col-md-12"> -->
    <div class="panel panel-full-color panel-full-danger">
      <div class="panel-heading " style="background-color: #d30000;">        
        <strong>PRICE LIST</strong>
        <div class="tools">           
          <label class="control-label panel-heading" style="color:white;">&nbsp;</label>      
          <select class="form-control " id="spro_firm" onchange="get_price_list(this.value);" style="margin-top:-32%;    background-color: antiquewhite;height:50%; width: 247px;">
            <option value="">Select firm</option>
            <?php foreach ($firm_data1 as $fd1){ ?>
            <option value="<?php echo $fd1['firm_id']; ?>"><?php echo ucwords($fd1['firm_name']);; ?></option>
            <?php } ?>
          </select>    
        </div>
      </div>      
    </div>
    <span id="datare">
         
    </span>
<!--   </div> -->
<!-- <div class="col-sm-12">
    <div class="panel panel-default panel-table">      
      <div class="panel-body"> -->
        <!-- <span id="datare">
         
        </span> -->
     <!--  </div>
    </div>
  </div> -->
</div>

<script>
  function get_price_list(id)
  {
    $.ajax({
      type: "POST",
      url: 'get_price_list.php',
      data: {id:id},
      success:function(msg) {
            // alert(msg);
            $('#datare').html(msg);
          }
        });
  }
</script>