Jump to content


Photo

calendar datetime problems


  • Please log in to reply
1 reply to this topic

#1 markbett

markbett
  • Members
  • PipPipPip
  • Advanced Member
  • 133 posts

Posted 25 August 2006 - 03:01 AM

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?

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 28 August 2006 - 10:03 PM

There are a series of date math functions, like MONTH(), for this purpose... but I don't really understand what you want to do.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users