❖ CLEARANCE INFORMATION:
$compID= $user_data['company']; $myDate = date_create() ->format("Y-m-d"); if(isset($_POST['done'])){ $recordID = mysql_escape_string($_POST['recordID']); $uID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $keyCode = mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); echo "".$sRow['cl_slip_info']." : (".$sRow['amount'].")
"; echo "".$sRow['cl_slip_date']." | ".$sRow['cl_slip_time'].""; }else{ echo "From: ".$senderName.""; echo "".$sRow['cl_slip_info']." : (".$sRow['amount'].")
"; echo "".$sRow['cl_slip_date']." | ".$sRow['cl_slip_time'].""; } echo"