Bob,
You should check out the Date::Manip module from CPAN, it will do what you
need to do. Here is a snippet from the docs about recurrence:
RECURRENCE
A recurrence is simply a notation for defining when a recurring event
occurs. For example, if an event occurs every other Friday or every 4
hours, this can be defined as a recurrence. With a recurrence and a
starting and ending date, you can get a list of dates in that period when
a recurring event occurs.
This should get you going with all the options you need.
Chris Hood
-----Original Message-----
From: Ramsey, Robert L [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 12, 2005 8:51 AM
To: mysql@lists.mysql.com
Subject: storing recurring dates
Hi,
I'm doing an event project and some of the events will be reccuring. For
example:
Monday, Wednesday, Friday from 10-11:30 am starting June 1 with no end
date
Every third Monday at 3-4 pm starting July 1 and ending January 1 (last
event is third Monday in December)
Every other Friday starting at 1pm with no set end time, starting June 3
Is there a good way to store those in a mysql database? So far the only
thing I can think of is that on entry, have a script figure out all of the
dates, which is pretty easy in php. Then for the events with no end date
set an arbitrary end date of 5 years in the future knowing that the
technology will probably change by then and the app will need to be
re-written.
Is there maybe some way or combination with the php strtotime function? I
know it can take something like "Third Thursday of October" and turn it
into a unix time stamp. But my brain is just not working today. ;)
Thanks,
Bob
--
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]
