calendar datetime problems

[markbett]

I am working on a site with a calendar.  events are being store in the MySQL DB as a date/time  (eg 2006/08/23 14:09:34 )  what I am trying to do is build a mySQL query so that i can read all of the events listed for each day.  so can i do a query  where i select by month year?

do i need to do SELECT * FROM events
ORDER BY start_day BETWEEN DATE 'DATE1'
              AND DATE 'DATE2'
and then i set the Date1 and Date2 variables independantly?
should i do  a query for each month and then sort and echo by day or should i runa  query for each day and run it every day of the month?

[fenway]

There are a series of date math functions, like MONTH(), for this purpose... but I don't really understand what you want to do.