Re: Automatic email to database member on X date?

2008-07-07 Thread Mauricio Tellez
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

Re: Automatic email to database member on X date?

2008-07-07 Thread John Meyer
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

Re: Automatic email to database member on X date?

2008-07-07 Thread boclair
This may be done basically by index.php, by running a script in the background that selects members whose levy is becoming due and have not already been notified , sends a standard email to the member's email address and updates a `notification_sent` field with, say, a timestamp value. A

Automatic email to database member on X date?

2008-07-04 Thread Aaron Norlund
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