IF statement not working

[markt97]

Hi,

My if statement is not working for session variables, please help!

 

Login page (Sets session):

 $email = mysqli_real_escape_string($con,$_POST['username']); 
   $pass = mysqli_real_escape_string($con,$_POST['password']); 
   $mysql = mysqli_query($con,"SELECT * FROM users WHERE email_address = '{$email}' AND password = '{$pass}'"); 
   $mysql2 = mysqli_fetch_array($mysql);
   if (!$mysql ||mysqli_num_rows($mysql) < 1)
   {
     die("Incorrect password!");
   } 
   $_SESSION['loggedin'] = "YES"; 
   $_SESSION['email'] = $email; 
   $_SESSION['fname'] = $mysql2['first_name'];
   $_SESSION['lname'] = $mysql2['last_name'];
   $_SESSION['add1'] = $mysql2['address_1'];
   $_SESSION['add2'] = $mysql2['address_2'];
   $_SESSION['county'] = $mysql2['county'];
   $_SESSION['postcode'] = $mysql2['postcode'];
   $_SESSION['tel'] = $mysql2['tel_no'];
   $_SESSION['mobile'] = $mysql2['mobile_no'];
   $_SESSION['team'] = $mysql2['team'];
   $_SESSION['ismanager'] = $mysql2['is_manager'];
   $_SESSION['isadmin'] = $mysql2['is_admin'];
   $_SESSION['sysadmin'] = $mysql2['is_sysadmin'];

Then on the profile page: 

 

<tr>
<td class="profile_tab">
    Is Team Manager?</td>
    <td class="profile_tab"><input style="text-align: center; font-size: 14pt;" type="text" value="<?PHP if($_SESSION['ismanager'] = "1") {echo "YES";} else {echo "NO";};?>" disabled size="50"></td>
</tr>
<tr>
<td class="profile_tab">
    Is Administrator?</td>
    <td class="profile_tab"><input style="text-align: center; font-size: 14pt;" type="text" value="<?PHP if($_SESSION['isadmin'] = "1") {echo "YES";} else {echo "NO";};?>" disabled size="50"></td>
</tr>
<tr>
<td class="profile_tab">
    Is System Administrator?</td>
    <td class="profile_tab"><input style="text-align: center; font-size: 14pt;" type="text" value="<?PHP if($_SESSION['sysadmin'] = "1") {echo "YES";} else {echo "NO";};?>" disabled size="50"></td>
</tr>

However the echo on the if statement doesn't work and just shows yes.....

 

I have changed in DB my value of is admin to 0 and it still says yes on my profile page,

 

Any help appreciated!

 

[AbraCadaver]

= is for assignment.  Try using == in the if statements.

 

You could also use:

<?php echo $_SESSION['sysadmin'] ? "YES" : "NO"; ?>

[markt97]

= is for assignment.  Try using == in the if statements.

Thanks, sorry it did work, forgot to log out and then in again!