Combine time and timestamp to select timed data in php and mysql

212 Views Asked by At

I have two columns in my MySql database activeAt(timestamp) activeAtTime(time)

I want to fetch data that are less than activeAtTime(timestamp) and activeAt(time)

The problem I'm facing in my code is if activeAt is 25th may & activeAtTime is 5pm of an particular post and If the fetch the data with below code at 26th may 2pm it is not getting listed, but if i fetch at 26th may 5:30 pm the post is getting listed

(i used medoo, but you can suggest any query)

 "activeAt[<=]" => date("Y-m-d"),
 "activeAtTime[<=]" => date("H:i")

eg a post with activeAt and activeAtTime

If i make a fetch request at 25th may, 8 am this post is not getting listed

I'm trying to make a blogs that posts based on scheduled time and date i tried bootstrap datetime picker but it didn't work Is there any way i can combine activeAt and ActiveATtime So that the above logic works
What will be the most efficient way to do it?.

0

There are 0 best solutions below