Little SQL Query Help

[Mr Chad]

How would i pull the new user? like i can get the total members by doing this:

// get forum members
$querya="SELECT COUNT(*) AS users, MAX(userid) AS max FROM " . $TABLE_PREFIX . "user WHERE usergroupid!=4";
$numa = mysql_query_eval($querya,$link);
$numb = mysql_fetch_array($numa);
$numbermembers=number_format($numb['users']);
mysql_free_result($numa);

what about the new user

[merk]

SELECT user.* FROM user ORDER BY userid DESC LIMIT 1

[Mr Chad]

SELECT user.* FROM user ORDER BY userid DESC LIMIT 1

thanks