Selected employee cannot be found in the database file... ";
}else{
$sql="INSERT INTO `pms_tickets` (`id`,`ticket_id`,`employee_id`,`emp_id`,`comp_id`,`deal_id`,`dept_id`,`concerns`,`date_sent`,`time_sent`,`sent_to_dept`,`sent_to_comp`,`current_status`,`level`,`year`,`created_by`)
VALUES('','$newTicket','$regByID','$regByEMPID','$compID','$dealCode','$deptCode','$concerns','$toDate','$currentTime','$xDeptCode','$xCompCode','NEW','$PriorityLevel','$mycYear','$myEMPID')";
if(!mysql_query($sql)){
die('Error: ' . mysql_error());
}else{
echo "
";
$message = "Hi ".$uFname."!
This is to confirm receipt of your request dated ".$toDate ." | ".$currentTime.". Autohub Support Team will attend to your concern as fast as possible.
Please always check your e-mail for updates or, you may login to our portal at http://www.autohub.ph/portal for real-time update of your request.
If you do not have an account yet, please visit the site and click Register.
Thank you.
Autohub Support Group";
mail($uMail, 'NEW TICKET CREATED', $message, 'From: support@autohubgroup.com');
}
}
}
?>
CREATE NEW TICKET