I have database "raj" with table "pagination"
In table pagination have "id", "actualtime" and "created" field
id - auto_increment name- varchar created- datetime
I want to display all rows which is created on todays date display upto yesterdays 06:00 pm.after that the content will be refreshed based on based on a DATETIME field called 'created' that holds the date and time of each record's creation.
this is my query to fetch rows but it is not working properly...plz help me......
$sql = " SELECT name FROM pagination where created >= DATE_SUB(CURRENT_DATE(),INTERVAL 1 DAY) ";