Re: [PHP-DB] making my own week? :)

2003-01-15 Thread Ignatius Reilly
The simplest seems to store the date normally in the DB. When you need your special Cinema date, just do a modulo 7: myDayOfWeek = ( WEEKDAY( '2003-01-17' ) + 3 ) % 7 HTH Ignatius - Original Message - From: Matthew Nock [EMAIL PROTECTED] To:

RE: [PHP-DB] making my own week? :)

2003-01-15 Thread John W. Holmes
I am currently building a website for a cinema - and a cinema week runs from Thursday, to Wednesday. I need some help with how to get PHP to work with one week periods, but having the week starting on a Thursday, instead of Sunday, or Monday. The week will be used to generate dynamic