[SOLVED] If statement problem

[whiskedaway]

Hi everyone! I was hoping you might be able to pick up what I've done wrong.

 

$cxn = mysqli_connect($host, $user, $password, $dbname) 
          or die ("Connection failed.");

$sql3 = "SELECT status FROM members
           WHERE username = '$_POST[fusername]'";
$result3 = mysqli_query($cxn, $sql3)
              or die ("Couldn't execute query 3.");

if ($result3 == "Super Administrator") {

    $message = "Super Admin.<br />";
}

else {

    $message = "You do not have permission to post comments.<br />";
}

 

Even when the status of the user is "Super Administrator", it is skipping the if bracket and going straight to the else. So I think there's a problem, probably with the way I'm calling $result3 in the if statement.

 

If anyone can help, it would be greatly appreciated.

 

Thank you!

[wildteen88]

$result3 is a result resource from the mysql query. You need to use mysqli_fetch_assoc in order to get the data retrieved from the query.

[whiskedaway]

Thanks, I forgot that statement. *headdesk* However, it's still not working. Here's the updated code:

 

$cxn = mysqli_connect($host, $user, $password, $dbname) 
          or die ("Connection failed.");

$sql3 = "SELECT status FROM members
           WHERE username = '$_POST[fusername]'";
$result3 = mysqli_query($cxn, $sql3)
              or die ("Couldn't execute query 3.");
$staff = mysqli_fetch_assoc($result3);

if ($staff == "Super Administrator") {

    $message = "Super Admin.<br />";
}

else {

    $message = "You do not have permission to post comments.<br />";
}

[MasterACE14]

$result3 = mysqli_query($cxn, $sql3)
              or die ("Couldn't execute query 3.");
$staff = mysqli_fetch_assoc($result3);

$staff = $staff['status'];

[whiskedaway]

It's still not working.

 

Oh and I queried the database just to make sure it was actually returning "Super Administrator", and it is. So it's a problem with the code.

[Btown2]

try this...

 

$status = mysql_fetch_array($result3) or die(mysql_error());

 

if($status[0] == "Super Administrator")

[whiskedaway]

There's a problem with that statement:

 

$staff = mysqli_fetch_array($result3) 
    or die("Couldn't execute fetch array");

if ($staff[0] == "Super Administrator") {

 

It brings up "Couldn't execute fetch array".

[MadTechie]

try this

<?php
$cxn = mysqli_connect($host, $user, $password, $dbname) or die ("Connection failed.");

$fusername= $mysqli_real_escape_string($_POST['fusername']); //stop SQL injection

$sql3 = "SELECT status FROM members WHERE username = '$fusername' ";
$result3 = mysqli_query($cxn, $sql3)or die ("Couldn't execute query 3.");

$staff = mysqli_fetch_assoc($result3);
if ($staff['status'] == "Super Administrator")
{
    $message = "Super Admin.<br />";
}else {
    $message = "You do not have permission to post comments.<br />";
}

?>

[whiskedaway]

That worked! Thank you.

[MadTechie]

welcome, can you click topic solved please (bottom right)