<?php
     session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');

    include("dbconnection.php");
		$sql2 ="SELECT * FROM save_activity WHERE srno='$_GET[srno]'";
		$qsql2 = mysqli_query($con,$sql2);
		if($re1 = mysqli_fetch_array($qsql2))
		{
		    
		   	include 'dashboarddocument.php';
}
?>
	  

  <?php

include 'fileheader.php';
?>



<h3 align='center'>Surgery Team</h3>
<?php
include("dbconnection.php");
	$sqlpatient = "SELECT * FROM save_activity WHERE  prescriptionid='$_GET[prescriptionid]' AND discription='Pre-Assessment Sheet<br>Surury Team<br>Doc.no-'";
	$qsqlpatient = mysqli_query($con,$sqlpatient);
	if($rsp = mysqli_fetch_array($qsqlpatient))
	{
	    if($rsp[discription]== 'Pre-Assessment Sheet<br>Surury Team<br>Doc.no-'){
	        echo"<h4>Doc.no : $rsp[srno]</h4>";

} else{
    echo "";
}
       
	}
?> 


 <table id="example2" class="table table-bordered table-hover">
                  <thead>
                  <tr>
                    <ul class='nav nav-pills ml-auto p-2'>
      
         <th><strong>Surgery Team</strong></th>
     <th><strong>Action</strong></th>
                </tr>
                  </thead>
                 
<?php
include("dbconnection.php");
		$sql ="SELECT * FROM surury_team WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
		    $sql1 ="SELECT * FROM site_users WHERE userno='$rs[team]'";
		$qsql1 = mysqli_query($con,$sql1);
		while($rs1 = mysqli_fetch_array($qsql1))
		    {
            echo " <tbody>
<tr>   <td>&nbsp;$rs1[name]</td> 
 <td><a href='PreOperativeAssessmentSheet.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[teamid]'>Remove</a></td>
    </tr>                   
          
          ";
		    }
}
?>          </tr>
                  </thead>
                  


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