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 <[EMAIL PROTECTED]>: > > 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/[EMAIL PROTECTED] > > -- Mauricio Tellez
