here is my login script.
basically i have an index.php which includes the login.php.
when i try to
$loginUsername=$_POST['Username'];
$password=$_POST['Password'];
$MM_fldUserAuthorization = "accessLevel";
$MM_redirectLoginSuccess = "index.php";
$MM_redirectLoginFailed = "login.php";
$MM_redirecttoReferrer = true;
mysql_select_db($database_purposebuilt, $purposebuilt);
$LoginRS__query=sprintf("SELECT authorUser, authorPwd, accessLevel FROM authors WHERE authorUser=%s AND authorPwd=%s",
GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text"));
$LoginRS = mysql_query($LoginRS__query, $purposebuilt) or die(mysql_error());
$loginFoundUser = mysql_num_rows($LoginRS);
if ($loginFoundUser) {
//initialize the session
$loginStrGroup = mysql_result($LoginRS,0,'accessLevel');
//declare two session variables and assign them
$_SESSION['MM_Username'] = $loginUsername;
$_SESSION['MM_UserGroup'] = $loginStrGroup;
if (isset($_SESSION['PrevUrl']) && true) {
$MM_redirectLoginSuccess = $_SESSION['PrevUrl'];
}
//echo "Login Successful";
}
else {
//echo "Login Fail";
}
anyone got any idea why this is happening?
