What is this 'Resource id #11' ??

Shagrath

I am making a basic forum script, and i am trying to get the username of the latest member that has signed up.

I've got the MySQL 'members' table set up, with the simple structure:

ID | USERNAME | PASSWORD | EMAIL ect...

But when i try to get the latest 'USERNAME' it just displays:
Resource id #11

The code im using to show the data is:

$var['stats']['newest_member'] = @mysql_query("SELECT 'USERNAME' FROM members ORDER BY 'ID' DESC LIMIT 0,1");

Any help on how i can display the 'USERNAME' field of the very last row in the table?

Thanks

pjleonhardt

cant you just say LIMIT 1 ??

Weedpacket

mysql_query gives you the full set of results. If you want to get the contents of that result set, you still need to use one of mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_row, or mysql_result.

pjleonhardt

heh, i didnt even catch that, silly me..
my question still stands though

Shagrath

Thanks fellas, i got it working

$var['stats']['newest_member'] = @mysql_query("SELECT USERNAME FROM members ORDER BY ID DESC LIMIT 1");
$var['stats']['newest_member'] = @mysql_result($var['stats']['newest_member'],"newest_member");

not sure if its 100% perfect, but it does the job 😃