[Xenon]

@echo: nope, because then it would display all posts from yesterday AND today

use this:

PHP Code:

// number of posts yesterday
$datecut = mktime(0,0,0,date("m"), date("d"), date("y"));
$getpoststoday=$DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline<='$datecut' AND dateline>=".($datecut-24*3600));
$poststoday=$getpoststoday[count];