Is there a way to display total users outside aMember?

Discussion in 'Integration' started by guanfulai, Jun 7, 2012.

  1. guanfulai

    guanfulai New Member

    Joined:
    Jul 14, 2010
    Messages:
    4
    Hello everyone,

    I'm running my business site with custom PHP pages + aMember v3.1.9, I want to display the aMember total active & expired user on my custom PHP homepage, is there a way to implement this?

    Thanks a lot!

    Roy
    guanfulai, Jun 7, 2012
    #1
  2. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Roy sure possible.
    You can get this info with two simple MySQL queries:
    select count(*) from amember_members where status=1 - will return active users count
    select count(*) from amember_members where status=2 - will return expired users count
    alexander, Jun 8, 2012
    #2

Share This Page