[Resolved] Why it doesn't authenticate?

[plasmahba]

Hi!

I'm making a login page where depending your "range" of user it takes you to different pages when you log in.

I have this code but probably I´m missing something here:

$rs = mysql_query($ssql,$Conn;

if (mysql_num_rows($rs)!=0){
session_start();
$_SESSION["autent"] = "YES";

if ($rs['Range'] == "administrator") 
    header("location : admin.php"); 
else 
    header("location: consulta.php"); 

}else { 
header("Location: login.php?baduser=yes"); 

}

Any of your input is greatly appreciated.

[tsinka]

Hi,

$rs is the result resource. In order to access the values you need to use e.g. mysql_fetch_array.

Example:

$rs = mysql_query($sql,$Conn); 

if (mysql_num_rows($rs) != 0){ 
  session_start(); 
  $_SESSION["autent"] = "YES"; 

  $arrRecord = mysql_fetch_array($rs);

  if ($arrRecord['Range'] == "administrator") 
    header("location : admin.php"); 
  else 
    header("location: consulta.php"); 
}else { 
  header("Location: login.php?baduser=yes"); 
} 

Another problem might be an SQL error. Try to use something like

$rs = mysql_query($sql,$Conn) or die(mysql_error());

to check for SQL or connection errors.

Thomas

[plasmahba]

Hi,

I used part of the code you post (thank you) and It seems to work well only for users Not Administrators. When your range is admin it takes you to a blank page with no error alert.

Any ideas?

Thanx

[tsinka]

Hi,

please post the updated authentication code including the SQL query.

Maybe ther is an error in admin.php. Try to put

ini_set("error_reporting",E_ALL);

at the very beginning of the admin.php script. Depending on the setup of PHP error reporting might be deactivated.

[plasmahba]

You won´t believe it but the only problem existing was a space between the location and the double colon
Instead Location : was Location:

Kinky

[dnast]

It's always the simple things... :p

By the way, you should click on the link below and mark you threads resolved.