format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['done'])){ $txtTINCompany = mysql_escape_string($_POST['txtTINCompany']); $userID = mysql_escape_string($_POST['userActiveID']); $txtTIN = mysql_escape_string($_POST['txtTIN']); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== mysql_query("INSERT INTO prf_changes_logs(action_taken,user_id,old_info,new_info,ref_number) VALUES('Change Company TIN','{$userID}','','{$txtTIN}','{$txtTINCompany}')"); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== mysql_query("UPDATE `vts_company` SET `comp_tin`='$txtTIN' WHERE `comp_id`='$txtTINCompany'"); echo ''; } exit(); ?>