调用多模型的最新文章

[e:loop={'select*from(selectid,classid,titleurl,filename,title,newstime,titlepicfrom[!db.pre!]ecms_moviewherenewstimeunionselectid,classid,titleurl,filename,title,newstime,titlepicfrom[!db.pre!]ecms_newswherenewstimeunionselectid,classid,titleurl,filename,title,newstime,titlepicfrom[!db.pre!]ecms_photowherenewstimeunionselectid,classid,titleurl,filename,title,newstime,titlepicfrom[!db.pre!]ecms_flashwherenewstimeunionselectid,classid,titleurl,filename,title,newstime,titlepicfrom[!db.pre!]ecms_articlewherenewstime)aorderbynewstimedesclimit10',10,24,1}]<ahref="<?=$bqsr['titleurl']?>"target="_blank"><?=$bqr['title']?></a><br>[/e:loop]帝国CMS多表调用最新信息,该演示代码为默认数据表下全站最新10条图片信息,自己根据需求可以附加条件,实现全站点击,全站头条,全站推荐等等.
注释：以上多个模型用“Union”连接调用
若只调用图片：要加ispic=1条件
举例：

[e:loop={'select*from(selectid,classid,titleurl,filename,title,newstime,titlepicfrom[!db.pre!]ecms_newswherenewstimeandispic=1unionselectid,classid,titleurl,filename,title,newstime,titlepicfrom[!db.pre!]ecms_photowherenewstimeandispic=1unionselectid,classid,titleurl,filename,title,newstime,titlepicfrom[!db.pre!]ecms_flashwherenewstimeandispic=1unionselectid,classid,titleurl,filename,title,newstime,titlepicfrom[!db.pre!]ecms_articlewherenewstimeandispic=1)aorderbynewstimedesclimit10',10,24,1}]<ahref="<?=$bqsr['titleurl']?>"target="_blank"><imgsrc="<?=$bqr['titlepic']?>"/><?=$bqr['title']?></a><br>[/e:loop]