UBB.Developers Forums UBB.threads 7 Development How Do I? query help

My friend is redoing our main page and he is trying to query the number of registered users. The forums and control panel say 1912 but when he queries he gets like 2900...I have deleted many inactive users over the years so what query would he use to get the active user number that matches the control panel number? I am using 6.51

SELECT count(*) FROM `w3t_Users

//user number
$result = @mysql_query("SELECT count(*) FROM w3t_Users");
$row = mysql_fetch_array($result);
$unum = $row["count(*)"];
//user name
$result = @mysql_query("SELECT U_Username FROM w3t_Users ORDER BY U_Number DESC");
$row = mysql_fetch_array($result);
$name = $row["U_Username"];
//print results
print "$unum";
echo (' Registered Users. Welcome to our newest member, ');
print "$name";

that is still giving me the wrong user name, it says in the sql that the U_Number field is auto inc... but the unmoded index page shows a totally dif. username for the latest user... what am i doing wrong?

try this

//user number
$result = @mysql_query("SELECT count(*) FROM w3t_Users");
$row = mysql_fetch_array($result);
$unum = $row["count(*)"];
//user name
$result = @mysql_query("SELECT U_Username FROM w3t_Users ORDER BY U_Registered DESC");
$row = mysql_fetch_array($result);
$name = $row["U_Username"];
//print results
print "$unum";
echo (' Registered Users. Welcome to our newest member, ');
print "$name";