session_start(); if (session_is_registered("valid_user")) { include("../include/FunctionDB.php"); ConnectDB(); $Teacher_code = htmlspecialchars(trim($_POST[Teacher_code])); $Username = htmlspecialchars(trim($_POST[Username])); $NewPassword = htmlspecialchars(trim($_POST[NewPassword])); $PasswordR = $NewPassword; $Password = md5($NewPassword); $sql ="UPDATE user_tb SET Username='$Username',Password='$Password',PasswordR='$PasswordR' WHERE Teacher_code='$Teacher_code' AND Flag='1'"; $result = mysql_query($sql) or die("Update Error $strSQL".mysql_error()); $sql2 ="UPDATE personal_tb SET Username='$Username',Password='$Password' WHERE Teacher_code='$Teacher_code'"; $result2 = mysql_query($sql2) or die("Update Error $strSQL".mysql_error()); if ($result && $result2) { echo"