sql count function - urgent and pls help
my program is used php + mysql.
how can i recount the total numbers of records shown in the screen when the time is 5am each day?
this is the sql for recount and updated the total records shown in the screen at mid night 12:00 everyday
$sql_s0 = "select count(*) from xx where Date >= current_date and Date < date_add(current_date, interval 1 day) ORDER BY Date DESC " ;