<?php

$DisplayForm=True;
include("../../dbconnection.php");
$sqlpatient1 = "SELECT * FROM list_Investigation WHERE ivid='$_GET[invid]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
    echo"
 	<table id='example2' class='table table-bordered table-hover'> 
            
               
	    <tr>
        <td>Select Investigation</td>
        <td>
<select onchange='BODYPARLOAD(this.value)' name='Category'>
<option value='' selected='selected'>Select Investigation</option>
<option value='10'>Ultrasound & Doppler</option>
<option value='11'>MRI</option>
<option value='12'>CT + 3D</option>
<option value='13'>X RAYS</option>
<option value='14'>Fluoroscopy</option>
<option value='15'>Mammography</option>
<option value='16'>Biometry</option>
</select>
</td></tr>
<tr><td>Body Part</td><td id='BODYPARTID'>
</td></tr>

<tr>
     <td>Request Investigation</td>
     <td id='RADIOBODYID'>
</td></tr>

</table>

   ";

} else{
    ?>
   
<?php

	$sqlpatient1 = "SELECT * FROM list_Investigation WHERE ivid='$_GET[invid]'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	if($rsn = mysqli_fetch_array($qsqlpatient1))
	{
$sql1 ="SELECT * FROM labdepartment WHERE labdepartmentid='$rsn[labdepartmentid]'";
$qsql1 = mysqli_query($con,$sql1);
	if($rs1 = mysqli_fetch_array($qsql1))
{
$sql12 ="SELECT * FROM radiobodypart WHERE 	radioid='$rsn[labdepartmentid]'";
$qsql12 = mysqli_query($con,$sql12);
	if($rs12 = mysqli_fetch_array($qsql12))
{
	    echo "
	    	<table id='example2' class='table table-bordered table-hover'> 
            
               
	    <tr>
        <td>Select Investigation</td>
        <td><input type='hidden' name='Category' value='$rs1[labdepartmentid]'>$rs1[lab_department_name]</td>
        </tr>
	    <tr>
        <td>Body Part</td>
        <td><input type='hidden' name='Sub_Category' value='$rs12[radiobodypartid]'>$rs12[bodypart]</td>
        </tr>
        <tr>
        <td>Request Investigation</td>
        <td><input type='hidden' name='Investigation' value='$rsn[ivid]'>$rsn[Investigation]</td>
        </tr>
	    
	    </table>";
				}
}
	}

?> 
  <?php
}
?>