= 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['phone']; $Query_user = "SELECT * from `shop_user` where phone='$new_email' "; $name_user=$DB->query($Query_user); $no_user=mysql_num_rows($name_user); $row_user = mysql_fetch_array($name_user); $men_country=$row['country']; $Query_c= "SELECT * from `shop_country` where name='$country' "; $name_c=$DB->query($Query_c); $row_c = mysql_fetch_array($name_c); $veh=$rowsss['vehicle']; $aaaaaaaa=$rowsss['amount']; $new_city_pundai=$row_user['city']; ?>
S.No Receipt No Reference Name Booked Date Mobile No Appointment Date City Problem Reports Details Status
OC- ( ) ( ) () : Rs999
() :