MYSQL下按时段统计个数命令及DEDECMS实例

例如dedecms，php代码：

//时段统计

$sqlsd="SELECT FROM_UNIXTIME(`time`,'%Y%m%d%H') AS hh, COUNT(*) AS cnt FROM js_sccess where time<$dayEnd AND time>$dayBegin GROUP BY hh";

$newsd = array();

$dsql->SetQuery($sqlsd);

$dsql->Execute();

while ($rowsd = $dsql->GetArray()) {

$newsd[] = $rowsd;

}

html模板代码：

<?php

foreach ($newsd as $newsdlist)

{

<td style="text-align:center"><?php

$sd=substr($newsdlist['hh'], -2);

$sdd=$sd+1;

echo $sd.':00-'.$sdd.':00';

?></td>

</tr>

<?php

}

所有的赏赐都只是被用来奖励工作成果的。