Little SQL Query Help

[Mr Chad]

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

PHP Code:

// 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]

[sql]
SELECT user.* FROM user ORDER BY userid DESC LIMIT 1[/sql]

[Mr Chad]

Originally Posted by merk

[sql]
SELECT user.* FROM user ORDER BY userid DESC LIMIT 1[/sql]

thanks