format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; //$myUID = $user_data['u_id']; if(isset($_POST['done'])){ $myDepartmentHead = mysql_escape_string($_POST['myDepartmentHead']); $MyUserID = mysql_escape_string($_POST['MyUserID']); $myDepartment = mysql_escape_string($_POST['myDepartment']); mysql_query("UPDATE `vts_users` SET `dept_id` = '$myDepartment',`dept_head_id`='$myDepartmentHead' WHERE `u_id`='$MyUserID'"); echo ''; } ?>