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?
calendar datetime problems
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users