Phpcms v9利用GET标签调用全站内容月排行

发布:smiling　来源: PHP粉丝网　添加日期：2014-10-19 21:06:14　浏览: 评论：0　

{pc:get sql="SELECT h.`monthviews`,n.`title`,n.`url`,n.`style` FROM `phpcms_hits` AS h,`phpcms_news` AS n WHERE substring_index(h.`hitsid`, '-', -1)=n.`id` AND n.`status`=99 ORDER BY h.`monthviews` DESC" num="20" cache="3600"}

{loop $data $v}

<li><span>{number_format($v['monthviews'])}</span><a href="{$v['url']}"{title_style($v['style'])} class="title" title="{$v['title']}">{str_cut($v['title'],56,'...')}</a></li>

{/loop}

{/pc}