[thelist] auto expiry of membership account

[Matt Warden]

On Sun, May 23, 2010 at 2:13 AM, saravana kumar <pgskr06 at gmail.com> wrote:
> Please some body help me to get php code for auto expiry of membership
> accounts. The members account should expire after 3 months , 6 months and 1
> year.

select
    user_id,
    (case when expiry_date >= sysdate then 'expired' else 'valid' end)
as account_status,
from user
where username='joe' and password='foo';

-- 
Matt Warden
Cincinnati, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.