Compare time advice
I am hoping someone can shed some light on this issue for me. Here is the scenario:
I have built a system that allows someone to input multiple events. Each event has a different time. Some may be at 3:30pm, some at 2:oopm .. etc. These events are displayed on a web page in order .. by date.
I have it currently setup so that when an event falls on the day of its scheduling, it is removed from the web page and then the next even is displayed. The order in which these are displayed is by date.
however... I know need to not only order by date.. I need to order by time... for example:
If an event is scheduled for 3:30pm today... this event should be displayed up until that time. Once 3:30pm hits, the next even is then displayed.
My current method only displays by date. So, if the event is 3:30pm, and 12:00am rolls around, on the day of the event, it is removed and the next even is displayed. This wont work because people should still be allowed to register for the event right up until the 3:30pm deadline.
I've done quite a bit of searching around a solution, and the more I search, the more confusing it becomes. So I am hoping someone can shed some light on this for me.