This ROLE ".$newRole." already Exist or inused. ";
}else{
$newRole = mysql_escape_string($_POST['newRole']);
$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']);
$roleStatus = mysql_escape_string($_POST['roleStatus']);
$roleCategory = mysql_escape_string($_POST['roleCategory']);
mysql_query("INSERT INTO vts_access_privilege (`a_desc`,`a_status`,`date_created`,`category`,`by`)
VALUES('{$newRole}','{$roleStatus}','{$svDate}','{$roleCategory}','{$svUserID}')");
//itexmo('09269172111', 'Hell Arnel E', $apicode);
$result = mysql_query("SELECT * FROM vts_access_privilege WHERE `a_status`=1 ORDER BY `a_desc` ASC");
?>
";
echo "
| NO |
ROLE DESCRIPTION |
STATUS |
DATE CREATED |
- |
";
while($row=mysql_fetch_array($result)){
$no=$no + 1 ;
echo "";
echo "| ".$no." | ";
echo "".$row['a_desc']." | ";
echo "";
if($row['a_status']==1){
echo 'Active';
}else{
echo 'InActive';
}
echo" | ";
echo "".$row['date_created']." | ";
echo "⚏ | ";
echo "
";
}
echo "";
}
exit();
}
?>