Posted by Michael Fesser on 07/21/07 17:08

..oO(Reapes)

>I have a script to remind me on certain days of things.
>
>The script allows a date of the reminder to be set as well as the number
>of days prior to the date to be reminded on via email.
>
>I am new to php so be gentle with my code (lol)
>
>Basically what I need to do is check the reminder date (called date in
>my mysql table) against todays date (only the month and day as the year
>is not used due to it going to be a year on year event) factoring in the
>number of days (reminderdays) prior to the date you want reminded of.

Let the database do it. Store the event dates in a DATE column. Then use
MySQL's date and time functions to return all events where the current
date is somewhere within the "reminding range".

Micha

[Back to original message]