<table id="example2" class="table table-bordered table-hover">
                  <thead>
         
						<tr>
						    <th>Medication Details</th>
							<th>Action</th>
						</tr>
				
      
                  </thead>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo" <tr>";
 echo "<td>&nbsp;<b>Date & Time : </b>$rs[created_at]<br><b>Drug : </b>
 ";
 if (is_numeric($rs[DRUGS]))
{
$sql1 ="SELECT * FROM medicine_stok WHERE medicine_id='$rs[DRUGS]'";
$qsql1 = mysqli_query($con,$sql1);
while($rs1 = mysqli_fetch_array($qsql1))
echo"$rs1[DRUGS_name]";
}
else
{
    echo"$rs[DRUGS]";
    }
echo" <br><b>Dose : </b>$rs[Dose]<br><b>Route : </b>$rs[Route]<br>"; echo "<b>Frequency :</b> ";
	   
switch ($rs[Frequency]) {
  case '01':
    echo "OD (Once Daily)";
    break;
      case '2':
    echo "BID/b.i.d. (twice a day)";
    break;
     case '3':
    echo "TID/t.id. (three times a day)";
    break;
     case '04':
    echo "QID/q.i.d. (four times a day)";
    break;
     case '1':
    echo "QHS (every bedtime)";
    break;
    
     case '6':
    echo "Q4h (every 4 hours)";
    break;
    
     case '4':
    echo "Q4-6h (every 4 to 6 hours)";
    break;
    
     case '0.143':
    echo "QWK (every week)";
    break;
    
        default:
    echo "";
} echo"<br><b>Duration : </b> $rs[duration]   ";
	   
switch ($rs[durationselect]) {
  case '1':
    echo "Days";
    break;
      case '7':
    echo "Week";
    break;
case '28':
    echo "Month";
    break;

        default:
    echo "";
}
echo"
		   </td>";	

echo"

              		 <td>&nbsp;<a href='medication/$rs[potential]'>Edit</a>|<form method='post' action='opdset.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]' name='status'><input type='submit' name='status' Value='Remove'></form></td>
              					
          </tr>                   
          
          ";
}


?>    </tbody>
  <tfoot>
          </tfoot>
        </table>