display new members

Discussion in 'Customization & add-ons' started by mousewalker, Jun 9, 2009.

  1. mousewalker

    mousewalker New Member

    Joined:
    Mar 16, 2009
    Messages:
    8
    Hi,
    On my home page, I have a list of members that have joined in the past 30 days( shown as active ). I would like to have this updated dynamically. Is there some way of pulling these names from the DB using PHP or java?

    Thanks,
    Michele
  2. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Sure you can use this sql query to get logins of these users:
    Code:
    select login from amember_members where status = 1 order by added desc limit 30
    

Share This Page