[SOLVED] putting data from sql into a variable then using it

[rhale]

what i am trying to do is just get a value from sql and then put it into a variable, it prints out the right value but when i try to use it in the if statement below it just doesnt work and i get no error or anything

 

$accesslevels = mysql_query("SELECT accesslevel FROM $tbl_name WHERE username='$myusername' and password ='$mypassword'");
$accesslevel = mysql_fetch_assoc($accesslevels);


if($accesslevel=='2'){
echo $accesslevel['accesslevel'];  
} 

[Alex]

I think you're meaning to do:

if($accesslevel['accesslevel']=='2')

[rhale]

tyvm that worked

 

i am very new to php and sql and am still just learning if that seemed like a real easy mistake