[SOLVED] Using a double if/else statement...

[dannyluked]

Hi,

Could anyone help me with code that does this:

 

if there isn't a SESSION['loggedin']

echo "not logged in"

elseif ($userlevel==0)

echo "...";

 

The only problem is that the variable $userlevel is a query and if there is no SESSION it gives an error;

$result = mysql_query("SELECT userlevel FROM ac_users WHERE username = '"$_SESSION['loggedin']"'")
or die(mysql_error());  

$row = mysql_fetch_array( $result );

$userlevel = $row['userlevel']

 

Thanks

[mikesta707]

....

 

if (!isset($_SESSION['loggedin'])){
echo "not logged in";
exit();
}
else {
$result = mysql_query("SELECT userlevel FROM ac_users WHERE username = '"$_SESSION['loggedin']"'")
or die(mysql_error()); 

$row = mysql_fetch_array( $result );

$userlevel = $row['userlevel'];
if ($userlevel == 0){
echo "..";
}
}

 

EDIT: Oh i see your problem now.

[dannyluked]

That gives the error:

Parse error: syntax error, unexpected T_VARIABLE in ... on line 62

 

line 62 is this line:

$result = mysql_query("SELECT userlevel FROM ac_users WHERE username = '"$_SESSION['loggedin']"'")

[mikesta707]

oh your mysql syntax was wrong. change to

 

$result = mysql_query("SELECT userlevel FROM ac_users WHERE username = '" . $_SESSION['loggedin'] . "'");

 

[KevinM1]

That gives the error:

Parse error: syntax error, unexpected T_VARIABLE in ... on line 62

 

line 62 is this line:

$result = mysql_query("SELECT userlevel FROM ac_users WHERE username = '"$_SESSION['loggedin']"'")

 

Put curly braces (i.e. { }) around $_SESSION['loggedin'] on that line.

[dannyluked]

Thanks, That worked perfectly!