<?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))
		{
		    
	
}
?>
	  

  <?php


?>



<?php

?>  
<div class="container">
    <div class="row">
        <div class="col-sm-6">
            
        </div>
        <div class="col-sm-6">
            <a href="edit_showpage_histopathology.php?prescriptionid=<?php echo $_GET['prescriptionid'] ?>&patientid=<?php echo $_GET['patientid'] ?>&surgeryid=<?php echo $_GET['surgeryid'] ?>" ><i class="fa fa-pencil-square-o" aria-hidden="true" style='font-size:20px;'></i>
</a>
        </div>
    </div>
</div>
  
    <?php
    $sql ="SELECT * FROM histopathology WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND surgeryid='$_GET[surgeryid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
		    echo "
<h3 align='center'>Histopathology</h3>
 <table id='example2' class='table table-bordered table-hover'>
 
 
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Diagnosis: </td>
<td width='50%'>$rs[Diagnosis]</td>
</tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Specimen: </td>
<td width='50%'>$rs[specimen]</td>
</tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp;  Investigation: </td>
<td width='50%'>"; ?>


<select class='selectva'  name="investigation" readonly>
        	<option value="">Investigation</option>
                        <?php
include("dbconnection.php");
	$sqlpatient1 = "SELECT * FROM `list_Investigation` where labdepartmentid='4'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{?>
	   <option value='<?php echo $rsn['ivid'] ?>' <?php echo ($rsn['ivid']==$rs['investigation'])? 'selected':'';?> ><?php echo $rsn['Investigation'] ?></option>";
			<?php	}
	
		  ?>

</select>

<?php echo "</td>
</tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Ref.by Dr: </td>
<td width='50%'>$rs[Ref_Dr]</td>
</tr>
 <tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Container no: </td>
<td width='50%'>$rs[Containerno]</td>
</tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Specimen Wt: </td>
<td width='50%'>$rs[specimen_wt]</td>
</tr>
";
}
?>

</table>