todays posts added count
by Prakash[ Edit ] 2013-08-03 16:49:11
To check todays posts added count use the following query.
select count(*) from posts where day(dat) = day(current_date) and month(dat) = month(current_date) and year(dat) = year(current_date)
In the above query the 'dat' field specifies the date post added.