Show the latest member on a non vb page???

[Zero767]

Hey, I really need to know how to show the latest member who joined on my homepage(not the vbulletin home; but rather my home site).

Thanks.

[rossco_2005]

Well i'm not sure if it's also available in the datastore/cache, but the way i'd do it is with a query like:

PHP Code:

$latestuser = $db->query_first("
SELECT username, userid
FROM ".TABLE_PREFIX."user
ORDER BY userid DESC LIMIT 1
"); 

[Zero767]

But dont I need to connect to the database?

What if I put that into a php file and put it into the vb folder then like included it where I want the user name, would that work?

Does anyone know? I really need help with this.