[Resolved] Problem with a database query within a function

[klik]

I have the following code, to try and show the newest member who has signed up to my site.

function newest_member()
{
$newest_member = @mysql_query("SELECT user_id, username
				FROM cms_users
				WHERE user_id > 0
				ORDER BY user_id DESC
				LIMIT 1");

// To display newest member:
echo "<b>Welcome our newest member, <font color=\"#FDBA19\">$newest_member</font></b>";
}

When i call the function however, the following appears:

"Welcome our newest member, Resource id #6"

I wanted 'resource id #6' to be replaced with the name of the user.

Do I need to adjust my code?

Thanks.

-Jay

[eoghain]

Yes you need to adjust your code. [man]mysql_query/man returns a resource link to the results of your query, not the actual results, you will need to access that data separately.

function newest_member() 
{ 
   $result = @mysql_query("SELECT user_id, username 
                FROM cms_users 
                WHERE user_id > 0 
                ORDER BY user_id DESC 
                LIMIT 1"); 

   // To display newest member: 
   $row = mysql_fetch_array($result);

   echo "<b>Welcome our newest member, <font color=\"#FDBA19\">" . $row['username'] . "</font></b>"; 
}

[devinemke]

you should do some reading on resource types.

function newest_member()
{
	$result = mysql_query('SELECT username FROM cms_users ORDER BY user_id DESC LIMIT 1');
	echo '<b>Welcome our newest member, <font color="#FDBA19">' . mysql_result($result, 0) . '</font></b>'; 
}

[klik]

Cheers mate.

Works perfectly. Thanks for the information, it will help me with future code.

[Roger_Ramjet]

Try marking your thread as RESOLVED (link at bottom). It will help us with your future problems.