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. Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.