Efficient MySQL Coding for a Calendar

[Anon]

I\'m using PHP to print a calendar and print event headlines into it, pulling the events data from a MySQL database. I could query MySQL for each day to determine if there are events on that day but this seems ineffecient and expensive. Can anyone suggest a more efficient method? Maybe somehow involving PHP\'s MySQL array fucntions? Thanks!

[Anon]

I wrote one that uses Oracle that queries events for the entire month and then loops through the array and reorganizes it so it's grouped by day. That shouldn't be too hard with MySQL.

[[deleted]]

Indeed. All database support date calculations.
In MySQL you can give a query like
SELECT *
FROM table
WHERE month(date_field)=2 and year(field)=2001;

and you'll get a list of all events scheduled in February 2001.
If you chang the query to something like

SELECT dayofmonth(date_field),
other_fields
FROM table
WHERE month(date_field)=2 and year(field)=2001;

Then you also get the day-of-month data, which is quite handy when printing data for certain days of the month.