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 " ;

thanks!

do you still need help with this? lol