Hi all. I have an online events directory and am having some issues with date calculations. I have a table of dates (next year) and an events table - which have a many to many relationship and so use an intermediary mapping table called dates_events. All good - when the user enters a single, multi-day, daily or monthly event the event is entered into its table and some calculations done to enter values in the mapping table. When I perform a search all the events fall on their specified dates.
Apart from weekly events that is. When a user enters a weekly event, the system looks at the start and end dates, finds out the ids of all the dates in the date table in increments of 7, and adds the mappings. When the weekly events are viewed, every 4 weeks they shift forward by one day over the week. There is some kind of ominous pattern here, but the maths is very simple (increment by 7) and so i thought I'd see if anyone can spot this right away before I dedicate my weekend to poring through PHP and mySQL date maths. Thanks in advance! -- http://www.web-buddha.co.uk
