I have a table with 4 schedule interval:
id time_int progr_comment A B C D
1 05:30:00 Good Morning 1 4 2 17
2 06:50:00 Have a nice day 1 4 2 17
3 17:00:00 Welcome Home 1 4 4 23
4 18:30:00 Good Evening 1 4 2 22
5 22:00:00 Good Night 1 4 2 20
For each interval I compare with NOW()
and I will take the variables (A, B, C, D) from table based on time_int <= NOW()
then my program create a query to mysql. The problem come after 0:00 hour. The query does not find anything until NOW()
pass the first interval (ex. 5:30:00).