统计记录:
select count(*) as total from [!db.pre!]enewszt
查询记录:
select ztid as id,ztname as title,ztimg as titlepic,ztpath as titleurl,addtime as newstime from [!db.pre!]enewszt order by ztid desc
list.var:
$rr=$empire->fetch1("SELECT GROUP_CONCAT(id) from phome_enewsztinfo where ztid='$r[id]'");
$ff=$rr[0];
$ga=explode(",",$ff);
for($i=0;$i<4;$i++){
if($ga[$i])
{
$cc=$empire->fetch1("select * from phome_ecms_game where id='$ga[$i]'");
$nr.='<a href="'.$cc[titleurl].'" target="_blank" class="hover_a"><img src="'.$cc[titlepic].'" alt="'.$cc[title].'" /><span class="b_bj"></span></a>';
}
}
$num=$empire->gettotal("select count(*) as total from phome_enewsztinfo where ztid='$r[id]'");
$listtemp='<li >
<div class="hj_top">
<a href="/[!--titleurl--]/" target="_blank"><img src="[!--titlepic--]" alt="[!--title--]" /></a>
<div class="hj_hover">
<div class="hj_bj"></div>
<div class="hj_a">
'.$nr.'
<a href="/[!--titleurl--]/" target="_blank" class="na">更多</a>
</div>
</div>
</div>
<div class="hj_bt">
<p class="title"><a href="/[!--titleurl--]/" target="_blank">[!--title--]</a></p>
<p class="intro"><span>[!--newstime--]</span><span><em>'.$num.'</em>个手游</span><a href="/[!--titleurl--]/">查看</a></p>
</div>
</li>';
© 版权声明
THE END
暂无评论内容