$Query_sp_in = "SELECT * from shop_category "; $name_fin_sp_in=$DB->query($Query_sp_in); $num_max_job_sp_in=mysql_num_rows($name_fin_sp_in); while ($name_j_sp_in = mysql_fetch_array($name_fin_sp_in)) { ?> } $get_app = mysqli_query($conn, "select * from tbl_appointment_office where id='$id_pay'"); $set_app = mysqli_fetch_array($get_app, MYSQLI_ASSOC); $formattedTime = sprintf('%02d:%02d', $set_app['hour_date'], $set_app['min_date']); $mytime = $formattedTime.' '.$set_app['am_date']; $msg.='