用灵动标签调用最新最多评论文章: [e:loop={select * from [!db.pre!]ecms_news where checked=1 order by plnum desc,id desc limit 8,10,24,0}]li smalla href=?=$bqsr[titleurl]? class=title?=sub($bqr[title],0,30,false)?/a/smallp?=$
本周热点排行之类的sql标签 [ecmsinfo]select * from phome_ecms_news where newstimeSUBDATE(NOW(),INTERVAL 7 DAY) order by onclick desc limit 10,10,30,0,24,7,0[/ecmsinfo] 注意: 30 是单位(天,当然你也可以修改单位为