帝国CMS调用所有数据表最新文章

[e:loop={'select * from (

select id,classid,titleurl,filename,title,newstime,titlepic from phome_ecms_news where newstime union

select id,classid,titleurl,filename,title,newstime,titlepic from phome_ecms_download where newstime union

select id,classid,titleurl,filename,title,newstime,titlepic from phome_ecms_photo where newstime union

select id,classid,titleurl,filename,title,newstime,titlepic from phome_ecms_flash where newstime union

select id,classid,titleurl,filename,title,newstime,titlepic from phome_ecms_movie where newstime union

select id,classid,titleurl,filename,title,newstime,titlepic from phome_ecms_shop where newstime union

select id,classid,titleurl,filename,title,newstime,titlepic from phome_ecms_article where newstime union

select id,classid,titleurl,filename,title,newstime,titlepic from phome_ecms_info where newstime) a order by newstime desc limit 7',7,24,0}]

<a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a>

[/e:loop]

注：表前缀phome_可以替换为通用的[!db.pre!] 或者 {$dbtbpre}

hhymw永久会员

打赏 收藏 海报 链接