welch Posted December 4, 2007 Share Posted December 4, 2007 im at a bit loss on how to start a 2 week schedule with php. What would be the best way to generate a table of 2 weeks ahead worth of options? Dec 4th 2007 -------------------------------------------------------------- Date | Am | PM | EV 12 / 4 | 1 | 1 | 1 12 / 5 | 1 | 1 | 1 12 / 6 | 1 | 1 | 1 and so on. Thanks Matt Quote Link to comment Share on other sites More sharing options...
BenInBlack Posted December 4, 2007 Share Posted December 4, 2007 you need to structure the table like this RowID Integer SchedDate date SchedTime time SchedWho Varchar 50 SchedEvent Varchar 255 and then you enter items as needed, you don't enter a table of all 2 weeks, it's a moving target and if you fill a database table with all dates for all people it will be immense, when you query you just from current date + 2 weeks and if it only returns 3 records that is fine you just show them. 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.