Jump to content


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


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
              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.