how to manage recurring events in database ?
subsequently we need to show this events in future dates.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$2 Answers
Store the events in an events table with the following fields:
id, startDate, endDate, recurrenceInterval
The events would start on the startDate and recur every x days where X is the recurrenceInterval.
If there are exceptions to the rule, you could store those in an exceptions table by event id.
Garnered some ideas from the discussion here:
http://forums.devx.com/showthread.php?threadid=136165
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
"Cron is the name of program that enables unix users to execute commands or scripts (groups of commands) automatically at a specified time/date." (Wikipedia) http://en.wikipedia.org/wiki/Cron
Use cron to run a script, that can handle the database event, at the time and date you specify.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
