0

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)

user3175451
  • 163
  • 1
  • 14

2 Answers2

1

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'];

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

Community
  • 1
  • 1
John Conde
  • 217,595
  • 99
  • 455
  • 496
  • I made the changes that you suggested. Now it gives me a null value. When I search the database with the same query, I get the column and value 1. How is it STILL not working :(( – user3175451 Jan 14 '14 at 03:06
  • `mysql_fetch_row` needs to be changed to `mysql_fetch_assoc` – John Conde Jan 14 '14 at 03:12
0

Do you more direct access to your database such as phpmyadmin? If so run your query there, with the literal expression of course: 

SELECT account_type from user_attribs WHERE username='lmfsthefounder'

what do you get back?

Jesse Adam
  • 415
  • 3
  • 14