posts yesterday (read me)

[corsacrazy]

this is the code 4 displaying total posts today:

PHP Code:

// number of posts today
$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'");
$poststoday=$getpoststoday[count]; 


so please could you help me modify it to display total posts yesterday ! cheers !

[EchoHype.com]

couldn't you just change the 2nd date value for day"d" to -1?

[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]; 


[EchoHype.com]

ahh alrighty.

hehe

[corsacrazy]

nice one xen master cheers