01.<?php
02. @$con_sh = $_POST['con_sh'];
03. $p = '%'.$con_sh.'%';
04. $q=mysqli_query($dbcon,"SELECT * FROM receive WHERE con_no LIKE");
05.
06.
07. while ($row = mysqli_fetch_array($q,MYSQLI_ASSOC))
08. {
09. $con_no=$row['con_no'];
10. $account_id=$row['account_id'];
11. $price=$row['price'];
12.
13. ?>
14. <tr>
15. <td><?php echo $row['con_no'] ?></td>
16. <td><?php echo $row['account_id'] ?></td>
17. <td><?php echo $row['price'] ?></td>
18.
19. </tr>
20. <?php } ?>
21.
22. <?php
23. $q2=mysqli_query($dbcon,"SELECT SUM(price) from receive");
24. while($row1=mysqli_fetch_array($q2))
25. {
26.
27. $mark1=$row1['SUM(price)'];
28. ?>
