|
|
Joined: Jun 2003
Posts: 88
Power User
|
Power User
Joined: Jun 2003
Posts: 88 |
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
|
|
|
|
Joined: May 2001
Posts: 550
Code Monkey
|
Code Monkey
Joined: May 2001
Posts: 550 |
SELECT count(*) FROM `w3t_Users
|
|
|
|
Joined: Jun 2003
Posts: 88
Power User
|
Power User
Joined: Jun 2003
Posts: 88 |
//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?
|
|
|
|
Joined: Oct 2003
Posts: 2,305
Old Hand
|
Old Hand
Joined: Oct 2003
Posts: 2,305 |
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";
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|