session_start(); date_default_timezone_set('Asia/Kolkata'); $browsessionid=$_REQUEST['confirm_id']; $login = "SELECT * from tbl_appointment WHERE session_id= '$browsessionid' "; $resqry = mysql_query($login) or die("ERROR:".mysql_error()); $numrows = mysql_num_rows($resqry); $Fetcorderid = mysql_fetch_array($resqry); $mailcopy=$Fetcorderid ['email_id']; $date=$rowsss['date']; $me_id=$Fetcorderid['mem_id']; $ap_date= $Fetcorderid['appointment_date']; $ap_hour= sprintf("%02d",$Fetcorderid['hour_date']); $ap_min= sprintf("%02d",$Fetcorderid['min_date']); $ap_sec= $Fetcorderid['am_date']; $Query = "SELECT * from `tbl_member` where id='$me_id' "; $name = mysql_query($Query) or die("ERROR:".mysql_error()); $no=mysql_num_rows($name); $row = mysql_fetch_array($name); $firstname= $row['name']; $skypeid=$row['skypeid']; sprintf("%02d", $to_hour); $Updatecart = mysql_query("UPDATE tbl_appointment SET `status`='1' WHERE `session_id`='$browsessionid' and status='0' "); $Msg1 = '
|
Your appointment has been confirmed and be ready 5 mins prior to the appointment timing