dfrance Posted May 2, 2009 Share Posted May 2, 2009 Hi I have a weekly shedule that I have put into a table using a mysql database, I need a way of producing the event for the given day and time that I visit my shedule, so say I visit my online shedule on tuesday @ 15:45 I need it to produce the events for the 2 hour window on the given day e.g. 14:00 - 15:59. So basically I need it to select a certain row in a table at the current time and day. so here is how my shedule is setup Days Monday/Tuesday/Wednesday/Thursday/Friday/Saturday/Sunday Times 08:00 - 09:59 10:00 - 11:59 12:00 - 13:59 14:00 - 15:59 16:00 - 17:59 18:00 - 19:59 20:00 - 21:59 22:00 - 23:59 00:00 - 07:59 Not asking for a complete script here just some pointers in the right direction. Regards, Dom. Link to comment https://forums.phpfreaks.com/topic/156527-php-shedule-help/ Share on other sites More sharing options...
ignace Posted May 2, 2009 Share Posted May 2, 2009 http://dev.mysql.com/doc/refman/6.0/en/comparison-operators.html#operator_between Link to comment https://forums.phpfreaks.com/topic/156527-php-shedule-help/#findComment-824221 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.