How to call the latest information from multiple tables in Imperial CMS

The example in this article describes the method of calling the latest information from multiple tables of Empire CMS. Share it with everyone for your reference. The specific implementation method is as follows:

The code is as follows:

[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_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_article where newstime) a order 
by newstime desc limit 10',10,24,1}]
[/e:loop]

Empire CMS multiple tables call the latest information. This demonstration code is the latest 10 picture information of the entire site under the default data table. You can add it according to your needs. Conditions to achieve full-site clicks, full-site headlines, full-site recommendations, etc. I hope this article will be helpful to everyone’s Imperial CMS website building. It is recommended to study "

Empire cms tutorial

"

The above is the detailed content of How to call the latest information from multiple tables in Imperial CMS. For more information, please follow other related articles on the PHP Chinese website!