Shulou(Shulou.com)06/02 Report--

Xiaobian to share with you what are the precautions of the Empire CMS7.0 universal label SQL call, I believe most people still do not know how, so share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

Empire CMS universal label SQL statement call is more flexible, is a lot of use empire CMS webmaster prefer a call way, however empire cms7.0 version and before version 6.6 but because of the adjustment of the data table structure and there are some differences.

Take the database phome_ecms_news that comes with the Empire CMS version 6.6 as an example. Its foreign news classid is 35. The following methods can be used to call the latest 5 pieces of data:

The code is as follows:

[ecmsinfo]'select * from [! db.pre!] ecms_news where checked=1 and classid=35 order by newstime desc limit 5 ' ,5,24,0,24,2,0[/ecmsinfo]

By analogy, the following statements can be used to call the latest data items 6 to 10:

The code is as follows:

[ecmsinfo]'select * from [! db.pre!] ecms_news where checked=1 and classid=35 order by newstime desc limit 5,5 ' ,5,24,0,24,2,0[/ecmsinfo]

However, if you use Imperial CMS 7.0, the above statement will be incorrect! The reason is that Empire CMS 7.0 separates out unaudited information, so there is no checked field in the table. At this time, the latest 5 pieces of information can be called with the following statement:

The code is as follows:

[ecmsinfo]'select * from [! db.pre!] ecms_news where and classid=35 order by newstime desc limit 5',5,24,0,24,2,0 [/ecmsinfo] The above is Empire CMS7.0 universal label SQL call notes what all the content, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.