Someone asked how to do this, so I figured it out. This little snippet works with PHPFanbase. What it shows is the total listed members plus those that are pending. So say you have 174 listed members and six pending, the total would show up as 180.
<? include(“config.php”);
$query=”SELECT * FROM $table WHERE apr=’y'”;
$result=mysql_query($query);
$num=mysql_numrows($result);
$query2=”SELECT * FROM $table WHERE apr!=’y'”;
$result2=mysql_query($query2);
$num2=mysql_numrows($result2);
?>
<br><b>Total members</b>: <?=$num+$num2?>
Page Views: 6 views
Loading ...
