[checkdizguyout]

Trying to find a script that will count the number of registered members on my site, and display it on the homepage. Any suggestions?

[Vulture]

How are you member details stored? If you have a table solely for member details, a simple count on that table would be all you'd need, eg

Code:

SELECT COUNT(*) FROM `table`;

[checkdizguyout]

My members are stored in an sql database... how do i use that code than to make that number viewable to people visiting the website....

[Vulture]

Ok, say, for example, that your members are stored in the table "users". Therefore every row in "users" is a different member. Here's how I would do it, although there are alternative methods.

PHP Code:

<?php

//db connection goes here



$query = mysql_query("SELECT COUNT(*) FROM `users`");

$count = mysql_fetch_array($query);



echo "We currently have <strong>{$count[0]}</strong> members.";



?>

One other way of doing it would be to take out the COUNT, perform a simple SELECT and use mysql_num_rows.

Hope that helps

[checkdizguyout]

thats what I was looking for, thanks alot!