Display number of members

[mightyb]

Just a simple bit of code i wrote for my pligg

// Number of members code start

We have:
<?php
// Query the database and get the count
$result = mysql_query("SELECT * FROM users");
$num_rows = mysql_num_rows($result);
// Display the results
echo $num_rows;
?>
&nbsp;members</a>

// Number of members code end 

Just drop this code whenever you want it in your template.

I will however add an extra sql query so if you have a very busy pligg this might not be a good idea.

[kbeeveer46]

there is already a stats mod included in Pligg. You can find it in the modules manager.

[savant]

if you are using that code, you can make it a bit more optimized by saying select id from users. that way mysql doesn't have to send all the information.

Just a simple bit of code i wrote for my pligg

// Number of members code start
 
We have:
<?php
// Query the database and get the count
$result = mysql_query("SELECT * FROM users");
$num_rows = mysql_num_rows($result);
// Display the results
echo $num_rows;
?>
&nbsp;members</a>
 
// Number of members code end 

Just drop this code whenever you want it in your template.

I will however add an extra sql query so if you have a very busy pligg this might not be a good idea.

[mightyb]

Ah well, i'm not really a coder. Just trying to help.