Problem: I only want a member's subsciption to last one year.

Solution: I need a script that will check a user's "registration date" in a mysql database and tell me a couple of month's before the year is over so i can inform the user to resubscribe.

Any help is appreciated