MySQL Forums
Forum List  »  PHP

Re: Temporal query with potential sub-query question.
Posted by: Roland Bouman
Date: July 27, 2005 01:02PM

just to be sure, some questions...

1) you want to see the first N events (is N a variable, or is it all, or is it fixed?) within a single timewindow between now() (starts the window always at now?) and some variable number of days (or is it always 7?)?

2) Is the recurring interval always 7 days?

3) In case of recurring = 1, can we assume that the first event start is always the same day as the day indicated by recurringDay, or should the actual first event date be derived from the event date and the recurringDay columns?

Options: ReplyQuote

Written By
Re: Temporal query with potential sub-query question.
July 27, 2005 01:02PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.