Or, you can use cron/at to schedule the task
Mauricio Tellez wrote:
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]