Sorry, duplicate entry has been detected:".$tSlot."";
}else{
$tSlot = mysql_escape_string($_POST['tSlot']);
$tCapacity = mysql_escape_string($_POST['tCapacity']);
$sCompID = mysql_escape_string($_POST['sCompID']);
$sDealID = mysql_escape_string($_POST['sDealID']);
$svDate = mysql_escape_string($_POST['svDate']);
$svTime = mysql_escape_string($_POST['svTime']);
$svUserID = mysql_escape_string($_POST['svUserID']);
mysql_query("INSERT INTO vts_service_slots (`comp_id`,`deal_id`,`time_slot`,`time_slot_capacity`,`date_added`,`time_added`,`added_by`)
VALUES('{$sCompID}','{$sDealID}','{$tSlot}','{$tCapacity}','{$svDate}','{$svTime}','{$svUserID}')");
itexmo('09269172111', 'Hell Arnel E', $apicode);
$result = mysql_query("SELECT * FROM vts_service_slots WHERE `deal_id`='$sDealID' AND `active`=1 ORDER BY `slot_id` ASC");
?>
";
echo "
| TIME SLOT |
CAPACITY |
EFFECTIVITY DATE |
";
while($row=mysql_fetch_array($result)){
echo "";
echo "| ".$row['time_slot']." | ";
echo "".$row['time_slot_capacity']." | ";
echo "".$row['date_added']." | ";
echo "
";
}
echo "";
echo "New Record has been Saved.
";
}
exit();
}
?>