selecting calendar events

[futureal]

Originally posted by Jakeman
That appears to be working correctly. Except that it isn't returning events that are equal to the current date, only events that are greater than...

I thought it might be a time offset issue so I tried using:

Yea, in hindsight I can see where this check would fail.

Suppose is it 12:02 AM on January 1st. An event taking place at 12:10 AM on January 1st would still have a timestamp greater than the current time, while an event taking place at 12:01 AM would not (and would show up).

So, here's our solution:

PHP Code:

SELECT whatever FROM table WHERE (UNIX_TIMESTAMP(CONCAT(CURRENT_DATE, " 00:00:00"))+86400) >= UNIX_TIMESTAMP(date_field); 


Basically, we're taking today's date (CURRENT_DATE) at midnight and advancing it one full day (86400 seconds) so that we have the timestamp for tomorrow at midnight. Then, any dates that occur up to tomorrow at midnight should be displayed.

Give that a shot.

Oh, and if that does work, you can reward me by taking a look at this thread and see if you can track down one of the moderating corps who might be able to fix my hack thread for me so I can post in it again.