<div class="row">
									<div class="col-xs-12">
									
										<div class="clearfix">
											<div class="pull-right tableTools2-container"></div>
										</div>
										<div class="table-header">
											ManageBook
										</div>

										<!-- div.table-responsive -->

										<!-- div.dataTables_borderWrap -->
										<div>
<table id="dynamic-table2" class="table table-striped table-bordered table-hover">
												<thead>
													<tr>
														
														<th>S.No.</th>

													<th>Appointment Details </th>

														<th class="hidden-480">Patient Details</th>
	<th class="hidden-480">Status</th>
														<th>
															<i class="ace-icon fa fa-clock-o bigger-110 hidden-480"></i>
															Action
														</th>
													

														
													</tr>
												</thead>

												<tbody>
												    <?php
		$a='0';
		$sql1 ="SELECT * FROM bookap WHERE adminid='$rs[entered_by]' AND statusva!='' ORDER BY srno DESC";
		$qsql1 = mysqli_query($con,$sql1);
		while($rspatient = mysqli_fetch_array($qsql1))
	{
	    $sql12 ="SELECT * FROM patient WHERE patientid='$rspatient[patientid]'";
		$qsql12 = mysqli_query($con,$sql12);
		while($rspatient12 = mysqli_fetch_array($qsql12))
	{
		$a++;
		?>	
													<tr>
													

														<td><?php echo $a; ?></td>

													 <td><b>Appointment Date </b><br>
             <?php  echo  $rspatient['selectdate']; ?><br>
               <b>Appointment Time</b>
               <br> <?php  echo $rspatient['SelectTime']; ?><br>
               <b>Type of Appointment</b><br> <?php  echo $rspatient['VisitConsultant'];  ?></td>

													<td><b>UHID</b> <?php  echo $rspatient['patientid'];  ?><br>
                 <b>Patient Name</b><br> <?php  echo $rspatient12['patientname']; ?></td>

														

														<td class="hidden-480">
															<span class="label label-sm label-<?php echo ($rspatient['statusva']=='new')?'success':(( $rspatient['statusva']=='Confirmed') ? "warning" : (( $rspatient['statusva']=='Awaiting' ) ? "inverse arrowed-in" : "danger"));  ?>"><?php echo $rspatient['statusva']; ?></span>
														</td>

														<td>
															<div class="hidden-sm hidden-xs action-buttons">
																<a class="blue" href="update_appoiment.php?srno=<?php  echo $rspatient['srno'];  ?>">
																	<i class="fa fa-pencil-square-o" style='font-size:20px; color:green'></i>
																</a>

															
															</div>

															<div class="hidden-md hidden-lg">
																<div class="inline pos-rel">
																	<button class="btn btn-minier btn-yellow dropdown-toggle" data-toggle="dropdown" data-position="auto">
																		<i class="ace-icon fa fa-caret-down icon-only bigger-120"></i>
																	</button>

																	<ul class="dropdown-menu dropdown-only-icon dropdown-yellow dropdown-menu-right dropdown-caret dropdown-close">
																		<li>
																			<a href="#" class="tooltip-info" data-rel="tooltip" title="View">
																				<span class="blue">
																					<i class="ace-icon fa fa-search-plus bigger-120"></i>
																				</span>
																			</a>
																		</li>

																		<li>
																			<a href="#" class="tooltip-success" data-rel="tooltip" title="Edit">
																				<span class="green">
																					<i class="ace-icon fa fa-pencil-square-o bigger-120"></i>
																				</span>
																			</a>
																		</li>

																		<li>
																			<a href="#" class="tooltip-error" data-rel="tooltip" title="Delete">
																				<span class="red">
																					<i class="ace-icon fa fa-trash-o bigger-120"></i>
																				</span>
																			</a>
																		</li>
																	</ul>
																</div>
															</div>
														</td>
													</tr>

												
					<?php }} ?>									
												

												</tbody>
											</table>
											
											</div>	</div>	</div>