From: Mauricio Tellez (mauricio.tellezgmail.com)
Date: Mon Jul 07 2008 - 02:08:29 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi Aaron, I'm not sure if what you want can be done with MySQL, but what you
can do is a little script in python, php, etc, that query your database for
the members that expire at a given date, and then email them. Then you tell
cron o similar to execute your script as often as you require. Hope it helps

2008/7/4 Aaron Norlund <aaronnorlundcomcast.net>:

>
> Hello all,
>
> I have no experience with MySQL, but am reading through the available
> texts. However, I feel what I need to do is probably way into these, so
> perhaps someone could give me a hand.
>
> I have taken over administering a website with a user database made with
> MySQL. It keeps track of members of our owner's association. I would like to
> set up a script that will automatically email member's when their membership
> expiration is nearing.
>
> Will someone please explain how this can be be accomplished, or point me
> in a direction to find out?
>
> I'm not sure if it helps, but we 'manage' the database through phpMyadmin.
>
> Thank you for your help!
>
> Aaron N.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=mauricio.tellezgmail.com
>
>

--
Mauricio Tellez

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]