View Single Post
Old 07-15-09, 03:00 AM   #5
Official pain in the ass
Tuork's Avatar
Join Date: May 2003
Posts: 1,197
Send a message via MSN to Tuork
Default Re: Timetable in MySQL

Well, let's say Tutor Andy has the following free period: Mondays, 1:00pm - 2:30pm.

Now let's say that little Billy wants Maths classes on Monday, from 1:00pm to 2:00pm.

I'd look up free time periods that match Billy's requirements, which would give me Andy's free period. The problem here is that the time periods don't match exactly, so I would need some way to re-define Andy's free period so that it no longer presents the initial hour. I'd have to mess with time differences, etc, which would make the algorithmic a tad more complicated than if, say, I used 30 minute periods all the time.

Does that make any sense?
My avatar: "An obscure and non sensical pattern made to get people to post what they think it is" - Vamp

Dell XPS M1530
Core2Duo T5550 1.86Ghz | 3GB DDR2 | 8600M GT 256MB | 250GB Hdd | BenQ FP202W 20" LCD | MX1000 mouse | Inspire T5400 5.1
Tuork is offline   Reply With Quote