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
:cry:

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()