สอบถามเกี่ยวกับวิธีการเขียน code ให้ search แล้ว sum เฉพาะที่ search ใน column

select sum(a) from table

<?php 
        @$con_sh = $_POST['con_sh'];
        $p = '%'.$con_sh.'%';
        $q=mysqli_query($dbcon,"SELECT * FROM receive WHERE con_no LIKE");
        
        
        while ($row = mysqli_fetch_array($q,MYSQLI_ASSOC))    
  {
        $con_no=$row['con_no'];
        $account_id=$row['account_id'];
        $price=$row['price'];
         
  ?>
  <tr>
        <td><?php echo $row['con_no'] ?></td>
        <td><?php echo $row['account_id'] ?></td>
        <td><?php echo $row['price'] ?></td>
       
  </tr>
  <?php } ?>
  
  <?php 
  $q2=mysqli_query($dbcon,"SELECT SUM(price) from receive");
  while($row1=mysqli_fetch_array($q2))
  {
  
    $mark1=$row1['SUM(price)'];  
 ?>