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'])){ $txtTINCompanyD = mysql_escape_string($_POST['txtTINCompanyD']); $userID = mysql_escape_string($_POST['userActiveID']); $txtTIND = mysql_escape_string($_POST['txtTIND']); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== mysql_query("INSERT INTO prf_changes_logs(action_taken,user_id,old_info,new_info,ref_number) VALUES('Change Dealer TIN','{$userID}','','{$txtTIND}','{$txtTINCompanyD}')"); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== mysql_query("UPDATE `vts_dealerships` SET `deal_tin`='$txtTIND' WHERE `deal_id`='$txtTINCompanyD'"); echo ''; } exit(); ?>