Re: time slots and PHP/MySQL

Don't want to get too philosophical, but don't PIM/Contact Management projects like TWIG have a feature like this? Now, this is just off the top of my head, but rather than create a timeslots table, wouldn't you have an event table, and a member_booked table? The minimum fields in event would be event_id(primary), start_time, end_time. Member_booked fields could be member_id, event_id, with maybe start_time and end_time, these two representing when the member is booked for an event. If a member is not found for a given event/time range in member_booked, presumably she's available. Note that "event" is generic, and could apply to any resource: meeting room equipment, meeting, etc. Downside to this, is that every member's scheduled event has to go into the member_event table, but it seems small so retrieval and update should be fast. Remember, this is a first kick at the can, and I'd bet there's a better way of doing it. Miles At 09:22 AM 8/21/2002 -0500, Matthew Crouch wrote:

this is a big question and i'm not trying to get you to do my modelling for me, but if anyone has experience with this i'd appreciate being pointed in the right direction: How could one efficiently manage time slots in a dB? I mean for example telling the dB that Mike can be somewhere at 6:15 or 6:30 but not 6:45, and that Cynthia can be there at 6:15 or 7:00... ...and so on my instinct is to create a "timeslots" table, but it looks like it would contain 35,040 records (one for each 15-minute period in the year). egad! The alternative is to create timeslots a month at a time or something, but the table would have to be reformulated every month. any thoughts? feel free to get philosophical about it. -M -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php