phpcms按照收藏量排序

{pc:get sql="select *,count(*) as count from hz_favorite where adddate>=DATE_SUB(CURDATE(),INTERVAL WEEKDAY(CURDATE()) DAY) group by title order by count(*) desc" return="data" num="4"}
{loop $data $key $val}
  {$val[title]}
{/loop}
{/pc}

posted on 2016-03-24 14:24  林旭涛  阅读(233)  评论(0编辑  收藏  举报

导航