Calendar

[Anon]

I need advice on a simple calendar program to try with our php3 code and mysql database. We currently store meetings in a table in mysql so I would like to also be able to modify the calendar code to also allow reading our meetings from our table. Any advice on the simplest type of calendar to try that is also flexible (i.e., we can modify to read our simple meetings table.) Am currently reading documentation on the following: http://modems.rosenet.net/calendar and http://mcal.chek.com

Much Thanks!

[[deleted]]

There a re a few snippets in the code library on this site that let you display months etc.

You just need to get the data from the table into the printout for each day.

You don't want to query the database for each day you print, because that would give you many pointless queries.
Instead I'd first query the database get all meetings for that month, ordered by date and time.
Then I'd start printing my days, starting with the first day.
Then I'd look at the first row of the results.
If the date of that first meeting is the same date as the date of the day I'm printing, I'd print the meeting
and move to the next row in the results.
If that date is also the date I'm printing, I'd again print that meeting. and so on untill the date is not the same as the date I'm printing. Then I'd move to the next day.
etc etc.

That would print the whole month with just one query to the database.