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