Lyleyboy Posted October 9, 2012 Share Posted October 9, 2012 Hey, I'm really after some advice on how to go about a task I have to do. I have written a small php/mysql app for my work that stores basic info about our customers. It's really very simple. What I have now been tasked to do is to add a project/task manager to it. The idea being that user1 is blocked out to work on project1 for three hours today and project3 for four hours. My issue is that I'm not sure how to go about blocking the time slots out in mysql. I don't really want to have to create slots in a database for every hour of every day. That seems a bit counter intuitive. Any genius plans that I'm going to slap myself for not coming up with myself. Thans folks. Quote Link to comment Share on other sites More sharing options...
Jessica Posted October 9, 2012 Share Posted October 9, 2012 You only store the times that are scheduled - start and end times. If nothing is scheduled during a "block", there won't be a row that has those times. 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.