Frequently Asked Questions

Script for total and pending members?

Where can I find the script snippet that displays the Total and Pending Member Counts for my fanlisting?

You can find that in the README file included in the zip file.

Total Members:

<?php include("config.php");
$query = "SELECT * FROM $table WHERE apr='y'";
$result = mysql_query($query);
$num = mysql_num_rows($result);
?> <p>We have a total of <strong><?php echo $num; ?></strong> members!</p>

Pending Members:

<?php include("config.php");
$query2 = "SELECT * FROM $table WHERE apr!='y'";
$result2 = mysql_query($query2);
$num2 = mysql_num_rows($result2);
?> <p>We have a total of <strong><?php echo $num2; ?></strong> pending <?php if ($num2 == "1"){ ?>member<?php } else { ?>members<?php } ?>!</p>

You only need to include config.php once, so if you’re using both of these snippets, make sure to delete the line that includes config.php in the second one. :)