Active Members by Product mySQL query statement

Discussion in 'Customization & add-ons' started by amnforms, Jun 26, 2011.

  1. amnforms

    amnforms New Member

    Joined:
    Mar 24, 2010
    Messages:
    5
    I am looking for a way to have either one or multiple mysql query statements.

    I want to be able to do a mysql search that will return the total number of active member for a specific product or by product. No difference.

    Either way, what I want to do is be able to capture the totals.

    I have several sites running amember and want to be able to have from one php page, get stats for all my different domains. Only way to do this is by querying the amember databases separately. However, I do not how to format the mysql query statement.

    Please help. Been trying to figure this out for months and it is beyond me.
  2. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,274
    Try this one :

Share This Page