= CURDATE() order by appointment_date asc "; $Query = "SELECT * from tbl_appointment where status='1' and date(appointment_date) = '$date_mas' order by appointment_date asc "; $namesss=$DB->query($Query); $nsssss=mysql_num_rows($namesss); $manssss='0'; while ($rowsss = mysql_fetch_array($namesss)) { $date=$rowsss['date']; $me_id=$rowsss['mem_id']; $status=$rowsss['status']; $document_name=$rowsss['document_name']; $Query = "SELECT * from `tbl_member` where id='$me_id' "; $name=$DB->query($Query); $no=mysql_num_rows($name); $row = mysql_fetch_array($name); $skypeid=$row['skypeid']; sprintf("%02d", $to_hour); $docname=$rowsss['document_name']; $new_email=$row['email']; $Query_user = "SELECT * from `shop_user` where email='$new_email' "; $name_user=$DB->query($Query_user); $no_user=mysql_num_rows($name_user); $row_user = mysql_fetch_array($name_user); ?>
S.No Receipt No Name Booked Date Mobile No Appointment Date City Problem Status
OC- () : USA Rs999
Direct () :