可以实现,调用最新300条信息中点中率最高的2条信息,而不是所有信息。
1 | [e:loop={ 'select * from (select a.id,a.title,a.newspath,a.newstime,b.classpath,b.classname,b.filetype,a.onclick,a.smalltext from ' . $dbtbpre . 'ecms_article as a,' . $dbtbpre . 'enewsclass b where a.classid=b.classid and a.checked=1 order by a.newstime desc limit 200) as new300 order by new300.onclick desc limit 2' ,1,24,0}] <li> <a rel= "nofollow noopener noreferrer" href= "[!---news.url--]<?=$bqr[classpath].'/'.$bqr[newspath].'/'.$bqr[id].$bqr[filetype ]?>" target= "_blank" title= "<?=$bqr[title]?>" ><h3><?=sub( $bqr [title],0,30,false)?></h3></a> <spn><?=sub( $bqr [smalltext],0,150,false)?>……</span> </li> [/e:loop] |
以上就是帝国CMS调用最新300条中点击率最高的2条。自己要先看得起自己,别人才会看得起你。更多关于帝国CMS调用最新300条中点击率最高的2条请关注haodaima.com其它相关文章!