Page 1 of 1
How Can I Show That Total Membership ?
Posted: Fri Jan 06, 2006 3:45 pm
by saqib389
how can i show that total membership in my site...
means how many ppl have been registered.. and the number of registered users i want to display
for example
total memberships : 102
please can any one tell me the code how can i add this feature...
Posted: Fri Jan 06, 2006 3:51 pm
by Jenk
Code: Select all
SELECT COUNT(*) AS `count` FROM `users`

Posted: Fri Jan 06, 2006 4:03 pm
by saqib389
i did this thing.. but its not showing the TOTAL MEMBERSHIP
any tutorial ?
Posted: Fri Jan 06, 2006 4:14 pm
by John Cartwright
What does your db table storing the users look like?
Posted: Fri Jan 06, 2006 4:29 pm
by saqib389
yes i m using mysql
here is the infoo
users table i creat in mysql
Code: Select all
CREATE TABLE users (
userid int(25) NOT NULL auto_increment,
first_name varchar(25) NOT NULL default '',
last_name varchar(25) NOT NULL default '',
email_address varchar(255) NOT NULL default '',
username varchar(25) NOT NULL default '',
password varchar(255) NOT NULL default '',
info text NOT NULL,
signup_date datetime NOT NULL default '0000-00-00 00:00:00',
activated enum('0','1') default NULL,
decrypted_password varchar(255) NOT NULL default '',
PRIMARY KEY (userid),
UNIQUE KEY username (username)
) TYPE=MyISAM COMMENT='Mysiteinfo';
then i want to get the total membership then i write this code
Code: Select all
$results = mysql_query("select count(*) as userid from users");
$get_row = mysql_fetch_array($results); // get 1 row
$totalmembers = $get_row['userid'];
echo $totalmembers;
still its not showing the total memberships
please tell me what shuld i do
Posted: Fri Jan 06, 2006 4:34 pm
by pickle
That query should do it. What happens when you run the query right in the database (either command line or PHPMyAdmin?)
Posted: Fri Jan 06, 2006 4:38 pm
by feyd
may want to check what $get_row has in it
var_export()