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
----- Original Message -----
From: "Matthew Nock" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 11:45 AM
Subject: [PHP-DB] making my own week? :)
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 list boxes, and database
Anyone done anything like this before that may be able to shed a little
If anyone is experienced with this sort of "date manipulation" let me know
what info you need and I will provide it where possible.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php