format("Y-m-d");
//if submit/ save to databasevar
if(isset($_POST['done'])){
$SelCompanyID = mysql_escape_string($_POST['SelCompanyID']);
$validatorID = mysql_escape_string($_POST['validatorID']);
$SelDelaerID = mysql_escape_string($_POST['SelDelaerID']);
$SelCategoryID = mysql_escape_string($_POST['SelCategoryID']);
//=====================================================================================================================================================
//=====================================================================================================================================================
$chkIfExist = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_company_asset_approver` WHERE `comp_id`='$SelCompanyID' AND `expense_item_id`= '$SelCategoryID' AND `deal_id`='$SelDelaerID'"),0);
if($chkIfExist > 0){
mysql_query("UPDATE prf_company_asset_approver SET `approver_id`='$validatorID' WHERE `comp_id`='$SelCompanyID' AND `expense_item_id`= '$SelCategoryID' AND `deal_id`='$SelDelaerID'");
//echo "SELECTED RECORD HAS BEEN UPDATED
";
}else{
//echo '';
mysql_query("INSERT INTO prf_company_asset_approver (comp_id, expense_item_id, approver_id,deal_id)
VALUES('{$SelCompanyID}','{$SelCategoryID}','{$validatorID}','{$SelDelaerID}')");
//echo "NEW RECORD HAS BEEN ADDED.
";
}
//echo '';
exit();
}
?>