Not sure why, but this is returning the wrong value. I WAS getting this resource ID #12 back, instead of the Number value '1' which I am seeking..
the code which did this was:
$type = "SELECT account_type from user_attribs WHERE username = '$username'";
$usertype= mysql_query($type);
so I changed that to this:
$type = "SELECT account_type from user_attribs WHERE username = '$username'";
$type_again = mysql_query($type);
$usertype = mysql_fetch_row($type_again);
Now it just gives me the word array. I am completely lost on this. Help?!
EDIT::
The current code being used is :
$username= 'lmfsthefounder';
$type = "SELECT account_type from user_attribs WHERE username='lmfsthefounder';";
$type_again = mysql_query($type);
$row = mysql_fetch_row($type_again);
$usertype = $row['account_type'];
echo $usertype;
which returns like this: Home Login Register Usertype is
(This should display 'Usertype is 1' in my navigation bar)
解决方案
You're almost there. You have the row containing the MySQL results which is what mysql_fetch_row() returns. Change that to mysql_fetch_assoc() which makes your code more readable. Then you just need the specific column value you seek which you van access by using it's name as the array key:
$type = "SELECT account_type from user_attribs WHERE username = '$username'";
$type_again = mysql_query($type);
$row = mysql_fetch_assoc($type_again);
echo $row['account_type'];