sql query to list all paid members

Discussion in 'Templates customization' started by manishie, Jul 2, 2005.

  1. manishie

    manishie Guest

    hi, i need an sql query that will list all members with active subscriptions. i can't seem to figure it out. what should it be?

    thanks.

    mkm
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    select * from amember_members where status > 0;
  3. manishie

    manishie Guest

    thanks!!!!!!!

Share This Page