Posted by Reapes on 07/21/07 18:39

Thanks Michael - how would I go about it ?

At the moment I am selecting all records which haven't been sent then
*trying* to check the explained dates and intervals.

R

Michael Fesser wrote:
> .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]