<!-- /.card-header -->
              <div class="card-body">
                <table id="example2" class="table table-bordered table-hover">
                  <thead>
                  <tr>
             <th><strong>Date & Time <br>Towards </strong></th>
          <th><strong>Medicine Charges <br>Status</strong></th>
            <th><strong>Assisted by </strong></th>
       <th><strong><section class="content-header">Action</section> </strong></th>             
        </tr>
      
                  </thead>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
    
		$qsql7 = mysqli_query($con,$sql7);
	$re7 = mysqli_fetch_array($qsql7);
	$sqlpatient = "SELECT SUM(pricetotal) as `price2`  FROM patient_invace WHERE prescriptionid='$rs[prescriptionid]' AND discription='Medicine_charge'";
	$qsqlpatient = mysqli_query($con,$sqlpatient);
	$rsp = mysqli_fetch_array($qsqlpatient);
	{
	    $sqlpatient2 = "SELECT * FROM patient_invace WHERE prescriptionid='$rs[prescriptionid]' AND discription='Medicine_charge'";
	$qsqlpatient2 = mysqli_query($con,$sqlpatient2);
  if($rsn2 = mysqli_fetch_array($qsqlpatient2))
	{
	$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rs[entered_by]'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    $pricedue=$rsp[price2]-$rsn2[collectprice];
            echo " <tbody>
            <tr>   <td>&nbsp;$rsn2[created_at] <br>$rsn2[discription]</td>
              		<td>&nbsp;$pricedue <br> Paid</td>
              		 <td>&nbsp;$rsn[name]</td>
              						<td><section class='content-header'><a href='$rsn2[link]' >View</a> </section></td>
          </tr>                   
          
          ";
}
}
}

}
?>    </tbody>
  <tfoot>
          </tfoot>
        </table>
        <br>
    <a href="#"><h1 Align="center"><i class="fa fa-file-pdf-o" aria-hidden="true"></i> View All </h1></h1></a>
      </div>