<!-- /.card-header -->
              <div class="card-body">
                <table id="example2" class="table table-bordered table-hover">
                  <thead>
                  <tr>
             <th><strong>Problem</strong></th>
          <th><strong>Date </strong></th>
          <th><strong>View</strong></th>              
        </tr>
        </tr>
                  </thead>
<?php
$sql ="SELECT * FROM prescription WHERE patientid='$_GET[patientid]' AND appointmentid='$_GET[appointmentid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
	$sqlpatient = "SELECT * FROM patient WHERE patientid='$rs[patientid]'";
	$qsqlpatient = mysqli_query($con,$sqlpatient);
	$rspatient = mysqli_fetch_array($qsqlpatient);
	
	$sqldoctor = "SELECT * FROM doctor WHERE doctorid='$rs[doctorid]'";
	$qsqldoctor = mysqli_query($con,$sqldoctor);
	$rsdoctor = mysqli_fetch_array($qsqldoctor);

            echo " <tbody>
            
            <tr>   <td>&nbsp;$rs[problem]</td>
            <td>&nbsp;$rs[prescriptiondate]</td>
					<td><a href='viewprese.php?prescription_id=$rs[0]&patientid=$rs[patientid]' >View</td>
          </tr>                   
          
          ";
}
?>    </tbody>
  <tfoot>
          </tfoot>
        </table>
      </div>
<?php
if(isset($_SESSION[doctorid]))
{
?>  
<hr>
	<table>
		<tr>
			<td>
			<div align="center"><strong><a href="prescription.php?patientid=<?php echo $_GET[patientid]; ?>&appid=<?php echo $rsappointment[appointmentid]; ?>">Add Prescription records</a></strong></div>
			</td>
		</tr>
	</table>
	<script>
  $(function () {
    $("#example1").DataTable({
      "responsive": true,
      "autoWidth": false,
    });
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
    });
  });
</script>

<?php
}
?>