I am writing a database that will be a basic listing of events happening in our local area. I need to know of the best way (with PHP and MYsql) how to store fortnightly events ?
Would I be best going from a start date then everytime it prints the page calculating what 2 weeks after that is till it hits a time after the current date ?
Atm im storing the date, name , location, if its regular, if regular how often (weekly fortnightly monthly).
Not exactly a mysql problem more of a need for some ideas. Any ideas would be helpful.
Would I be best going from a start date then everytime it prints the page calculating what 2 weeks after that is till it hits a time after the current date ?
Atm im storing the date, name , location, if its regular, if regular how often (weekly fortnightly monthly).
Not exactly a mysql problem more of a need for some ideas. Any ideas would be helpful.