数据显示处理
时间段 机种 数量 2012-02-08 08 ETC56-542N 432012-02-08 09 ETC56-542N 372012-02-08 10 ETC54-623N 162012-02-08 10 ETC54-628N 22
时间段 ETC56-542N ETC54-623N ETC54-628N 数量合计 08:00:00-09:00:00 43 4309:00:00-10:00:00 37 3710:00:00-11:00:00 16 22 38
SELECT DATE_FORMAT(`date`,'%Y-%m-%d %H') as time,type,count(*) as count FROM `barcode_2d` WHERE date >= '".$thisday2." 08:00:00' AND date < '".$thisday." 08:00:00' GROUP BY type , time ORDER BY date ASC