How to filter data from database according to client name & date wise in PHP

In above example we search data for client name digital Dhaval ror date 1-08-2019 to 21-08-2019

//             CODE   // 
<div class="demo-content" >
<div align="center"  >
  <form name="frmSearch" method="post" action="">
<p class="search_input">
<select name="company" id="select" class="" >
<option value="Select" name=company" id="comapny">Select</option>
<option value="Administrator" name=company" id="comapny">Administrator</option>
<?php  $company="select * from clients";
 $row=mysql_query($company);
 while($data=mysql_fetch_array($row))
 {
  echo $name=$data['name'];
 $id=$data['id'];

?>


 <option value="<?php echo $id;   ?>"><?php echo $name;   ?></option>

 <?php } ?>
 </select> 
 <br><br>
 <?php
$conn = mysqli_connect("localhost", "root", "", "database name");

$post_at = "";
$post_at_to_date = "";
$company = "";

$queryCondition = "";
if(!empty($_POST["search"]["post_at"])) {
$post_at = $_POST["search"]["post_at"];
list($fiy,$fim,$fid) = explode("-",$post_at);


$post_at_todate = date('Y-m-d');
if(!empty($_POST["search"]["post_at_to_date"])) {
$post_at_to_date = $_POST["search"]["post_at_to_date"];
list($tid,$tim,$tiy) = explode("-",$_POST["search"]["post_at_to_date"]);
$post_at_todate = "$tiy-$tim-$tid";
}

$queryCondition .= "WHERE company_id = '".$_POST['company']."'  AND `issuedate` <= '" . $post_at_todate . "'  AND `issuedate` >= '$fid-$fim-$fiy'"; 

}

        $sql = "SELECT * from table " . $queryCondition . " ORDER BY date  desc ";
$result = mysqli_query($conn,$sql);
?>
 
<input type="text" placeholder="From Date" id="post_at" name="search[post_at]"  value="<?php echo $post_at; ?>" class="input-control" />
    <input type="text" placeholder="To Date" id="post_at_to_date" name="search[post_at_to_date]" style="margin-left:10px"  value="<?php echo $post_at_to_date; ?>" class="input-control"  />  
<input type="submit" name="go" value="Search" >
</p>
</div>

<?php if(!empty($result)) { ?>
<table >
          <thead>
        <tr>
                      
          <th ><span>Company</span></th>
          <th><span>Error</span></th>          
          <th><span>Date</span></th>
<th width="20%"><span>Status</span></th>   
        </tr>
      </thead>
    <tbody>
<?php
while($row = mysqli_fetch_array($result)) {
$status=$row["status"];
?>
        <tr>
<td><?php echo $row["company"]; ?></td>
<td><?php echo $row["error"]; ?></td>
<td><?php echo $row["issuedate"]; ?></td>
<td> <?php if($status==1){ ?><font color="red">Message Sent </font><?php }?>
  
  
  <?php if($status==2){ ?><font color="green">Work In Progress </font><?php }?>
  
  <?php if($status==3){ ?><font color="blue">Work assigned to programmer </font><?php }?>
  
 <?php if($status==4){ ?><font color="blue">Work In Progress </font><?php }?>

 <?php if($status==6){ ?><font color="green">Ticket closed </font><?php }?> </td>

</tr>

   <?php
}
   ?>
   
   <tbody>
  </table>
<?php }    ?>

  </form>
  </div>