1. 

   pilot New Member

   Joined:

   May 24, 2003

   Messages:

   178

   I am trying to remove the subscriptions from my database that are older than 2006.
   
   Amember will not do this, so does anyone know what the query in mysql to do this in PhpMyadmin?
   
   Many thanks in advance

   pilot, Oct 8, 2009

   #1
2. 

   alexander Administrator Staff Member

   Joined:

   Jan 8, 2003

   Messages:

   6,279

   You can use query:
   

   Code:

   delete from amember_payments where expire_date < '2006-01-01'
   

   This will remove all subscription that have expire date less then Jan 1st of 2006

   alexander, Oct 9, 2009

   #2

• Login with Facebook

Your name or email address:

Password:

Forgot your password?

Stay logged in