Jump to content

Archived

This topic is now archived and is closed to further replies.

markbett

calendar datetime problems

Recommended Posts

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?

Share this post


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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.