<?php
session_start();
include("dbconnection.php");
$sql ="select * from opdmatrix where Specialization='$_GET[stid]'";
$qsql = mysqli_query($con,$sql);
while($qsql3=mysqli_fetch_array($qsql))
{
$sql ="select * from admin where id='$qsql3[adminid]'";
$qsql = mysqli_query($con,$sql);
while($qsql2=mysqli_fetch_array($qsql))
{
echo "
<div  class='wrap-input100 input100-select'><select class='form-control' name='Selectstate' id='Selectstate'><option value=''>Select State</option>
 <option value='$qsql2[Selectstate]'>$qsql2[Selectstate]</option></select><span class='focus-input100'></span></div>";
 $sql ="select * from admin where id='$qsql3[adminid]' AND Selectstate='$qsql2[Selectstate]'";
$qsql = mysqli_query($con,$sql);
while($qsql4=mysqli_fetch_array($qsql))
{
    echo"<span class='label-input100'>City Name</span>
<div  class='wrap-input100 input100-select'>
 <select class='form-control' name='Selectstate' id='Selectstate'><option value=''>Select City</option>
 <option value='$qsql4[Selectdistrict]'>$qsql4[Selectdistrict]</option></select>
 <span class='focus-input100'></span>
</div>";
  $sql ="select * from admin where id='$qsql3[adminid]' AND Selectdistrict='$qsql4[Selectdistrict]'";
$qsql = mysqli_query($con,$sql);
while($qsql4=mysqli_fetch_array($qsql))
{
    echo"<span class='label-input100'>Hospital </span>
<div  class='wrap-input100 input100-select'>
 <select onchange='loaddr(this.value)' class='form-control' name='Selectstate' id='Selectstate'><option value=''>Select Hospital</option>
 <option value='$qsql4[id]'>$qsql4[hsname]</option></select><span class='focus-input100'></span>
</div>";
 $sql ="select * from dr where entered_by='$qsql3[adminid]' AND Specialty='$_GET[stid]' AND city='varanasi' ";
$qsql = mysqli_query($con,$sql);
while($qsql3=mysqli_fetch_array($qsql))
{
	echo" 
							       <table>
							       <tr>
      <tbody>   <th>Select </th>
              <th> Name </th>
                 <th>Profile</th>
         </tr>
          <td><b><input type='radio' onchange='loadtime(this.value)' value='$qsql3[drid]' name='drid'></b></td>
            <td>$qsql3[Drname]</td>
                 <td>
<a style='color:blue' target='_blank' href='drprofile.php?drid=$qsql3[drid]'>View Profile</a></td></tr>
   
		  </tbody>
		  </table>";		
}
}
}
}
}
?>