format("Y-m-d"); //if submit/ save to databasevar if(isset($_POST['done'])){ $newExpenseSub = mysql_escape_string($_POST['newExpenseSub']); $userID = mysql_escape_string($_POST['userID']); $prfCode = mysql_escape_string($_POST['prfCode']); $curExpenseSubTypeName = mysql_result(mysql_query("SELECT `description` FROM `prf_expenseitems` WHERE `id`='$newExpenseSub'"),0); mysql_query("UPDATE `prf_request_hdr` SET `sub_category_id`='$newExpenseSub' WHERE `reference_code`='$prfCode'"); mysql_query("UPDATE `prf_request_detl` SET `sub_category_id`='$newExpenseSub' WHERE `header_ref_code`='$prfCode'"); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== mysql_query("INSERT INTO prf_changes_logs(action_taken,user_id,old_info,new_info,ref_number) VALUES('Change Expense Sub Type','{$userID}','','{$newExpenseSub}','{$prfCode}')"); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== echo "

Expense Type: ".$curExpenseSubTypeName."

"; } ?>