频道总排行调用方法
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
<div
class
=
"box"
>
<h5
class
=
"title-2"
>频道总排行</h5>
{pc:get sql=
"select a.id,a.title,a.url,a.catid,b.hitsid,b.views from v9_news a left join v9_hits b on a.id=substring(b.hitsid,5) where a.catid in ($arrchildid) order by b.views desc"
num=
"10"
cache=
"3600"
}
<ul
class
=
"content digg"
>
{loop
$data
$r
}
<li> <a href=
"{$r[url]}"
title=
"{$r[title]}"
target=
"_blank"
>{str_cut(
$r
[title],36,
'...'
)}</a></li>
{/loop}
</ul>
{/pc}
</div>
|
本文转自 gutaotao1989 51CTO博客，原文链接:http://blog.51cto.com/taoyouth/1588246
