[SOLVED] annoying.. resource id #5

[Mr. R]

Hi, i have this annoying little problem when trying to see the rank of a user, this is the simple bit of code im using...

 

$result = (mysql_query("SELECT rank FROM users WHERE username = '$username'"));
if ($result == "admin") {
echo "You are an admin.";
}else{
	echo "You are not an admin";
	echo $result;
}

 

Even though the user is an admin, the output i get is... "You are not an adminResource id #5"

 

 

Can anyone help me?

 

Thanks

[pocobueno1388]

<?php

$result = mysql_query("SELECT rank FROM users WHERE username = '$username'");
$row = mysql_fetch_assoc($result);

if ($row['rank'] == "admin") {
  echo "You are an admin.";
}else{
	echo "You are not an admin";
	echo $row['rank'];
}

?>

[Mr. R]

Yes! it works, thanks a lot mate, its been annoying me for ages.