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 d

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]>