Display total active subscribers count

Discussion in 'Templates customization' started by gusfune, Mar 4, 2011.

  1. gusfune

    gusfune New Member

    Joined:
    Feb 20, 2011
    Messages:
    11
    Is it possible to display the total active subscribers count in Amember? Also, is it possible to display total user count: both active and expired?

    How can that be be applied on a PHP page?

    Thanks.
  2. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,437
    Doesnt it show up on the amember admin screen- right middle side?
    Also, you can go to email, send to active users, will give you a count.

    David
  3. gusfune

    gusfune New Member

    Joined:
    Feb 20, 2011
    Messages:
    11
    Actually I was looking forward displaying it on the website.

    I figured out a way of doing so in Wordpress Integration, but for general PHP pages it's not the same.
  4. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    In php you can use this code:
    PHP:
    include "/full/path/to/amember/config.inc.php";
    $active $db->query_one("select count(*) from amember_members where status = 1");
    $total $db->query_one("select count(*) from amember_members where status in (1,2)");

Share This Page