[RESOLVED] Redirect to different pages after login

[pb1uk]

Hello all,

For the site i am setting up i want to have one login form to log in both normal users and administrators.

For the login form i want users to be redirected to the user homepage and likewise for the admins. The field level_user in the database holds the access level which is 1 for a user and 0 for an admin.

Part of my login code to try and do this is below, is just can't figure it out, any help would be greatly appreciated. thanks

$LoginRS__query=sprintf("SELECT username_user, password_user, level_user AS 'level' FROM tbl_user WHERE username_user=%s AND password_user=%s",
  GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); 

  $LoginRS = mysql_query($LoginRS__query, $frox_db) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {

$loginStrGroup  = mysql_result($LoginRS,0,'level');

//declare two session variables and assign them
$_SESSION['MM_Username'] = $loginUsername;
$_SESSION['MM_UserGroup'] = $loginStrGroup;	      

if (isset($_SESSION['PrevUrl']) && false) {
  $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
}
if('level'==0)
{
header("Location: " . $MM_redirectLoginSuccessAdmin );
}
else
{
header("Location: " . $MM_redirectLoginSuccessUser );
}

[bradgrafelman]

Couple of issues:

1. In your query, the column alias you specify after the "AS" keyword should not be a string - it should be listed as any other column identifier would be (that is, using either no delimiters at all or using the proper delimiter, e.g. a backtick or possibly a double quote).

2. Since you already know the username and password, why are you SELECT'ing them in your query as well? If you only care about the level column, then only SELECT that column.

3. This if() statement:

   if('level'==0) 

   is checking to see if the string "level" is equal to the number zero. Obviously, this doesn't make much sense. If you retrieved the level into the variable $loginStrGroup, then why aren't you checking that variable to see if it's 0 or not?

[pb1uk]

Thanks bradgrafelman, much appreciated.

The reason the code was like that was because i was using Dreamweaver log in user authentication behaviour and that's part of the code it generates

By changing

if('level'==0)

to use $loginStrGroup instead of 'level' the code works fine.

Thanks for your help and pardon my ignorance