samona Posted December 28, 2007 Share Posted December 28, 2007 Hi all, I want to write a calendar in PHP and MySQL, but I'm not sure about the tables I will need. How do simulate each month and year in a database. Do I have to have one table for each month. That would be hard to do for say 10 years. Quote Link to comment Share on other sites More sharing options...
fenway Posted December 28, 2007 Share Posted December 28, 2007 Describe exactly what you're trying to describe. Quote Link to comment Share on other sites More sharing options...
revraz Posted December 28, 2007 Share Posted December 28, 2007 Well your database can go as long out as you want it to. But what I do is just display the current month/year and provide a pulldown so they can change to any month and year within the next 3 years. But the DB will accept any future entry as far out as they want. If you want the basics of designing the layout, the do a google search for calendar tutorial php and that will give you a start to display the calendar. Then you can work on incorporating the DB entries. 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.