select DATE_FORMAT(FROM_UNIXTIME(date),'%Y-%m-%d') as d, count(*) as c from tb where (FROM_UNIXTIME(date)) >= (FROM_UNIXTIME('1370275200')) and (FROM_UNIXTIME(date)) <= (FROM_UNIXTIME('1376074551')) group by d Read More
function getDates($start, $end) { $dt_start = strtotime($start); $dt_end = strtotime($end); do{ echo date('Y-m-d', $dt_start).'; } while(($dt_start += 86400) <= $dt_end);}getDates('2013-02-28','2013-03-02'); Read More