Member Count Function

[brown2005]

function MembersCount()
{

$MembersCountSql = mysql_query("SELECT * FROM members WHERE members_activated='1';");
$MembersCountRows = mysql_num_rows($MembersCountSql);

$MembersCountRows = number_format($MembersCountRows);

return $MembersCountRows;

}

Is there any better way to write the above?

[obsidian]

[code]
<?php
function membersCount() {
  $count = mysql_result(mysql_query("SELECT COUNT(*) AS count FROM members WHERE members_activated = '1'"), 0, 'count');
  return $count;
}
?>
[/code]

That should work... try to let MySQL do the crunching for you.