phpcms V9收藏量统计全站排行
时间:2016-06-14 来源:风信官网 点击:
629次
phpcms V9 收藏量统计全站排行代码,可获取用户ID,文章title,URL及收藏时间数据信息
{pc:get sql="select *, count(*) as count f rom v9_favorite where adddate >=DATE_SUB (CUR DATE(), INTERVAL WEEKDAY(CURDATE()) DAY) group by title order by count(*) desc" return="data" num="9"}
{loop $data $key $val}
{$val[title]} {$val[count]}
{/loop}
{/pc}