|
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
Navigation:
[Reply to this message]
|