Recently in using Phpcms V9 to make a station, found that get tags very useful, custom model after get almost become omnipotent. But Phpcms upgrade to V9, the 2008 of a lot of functions are removed, such as the get tag, in the back automatically added a limit 0, 20, so you even write the num= ' number ' is useless, written in SQL statements, such as
{PC: Get sql="SELECT * from V9_news ORDER by ID DESC LIMIT 2,5" cache="3600" page="$page" Dbsou Rce=return="Data"}
Will error, the printed SQL statement is:
2,0,
This is obviously wrong. 2 methods were found on the forum, the second of which was the most absolute, and the code was directly affixed:
1. For example,
{PC: Get sql="Select Title,url from V9_news where catid=9 and status=99 order by updatetime Desc" Start=< c12> "0" num=return="V"}
can be controlled by adding start and Num.
2. (The more absolute method)
{PC: Get SQL=return="V"}
Note the two minus sign after 4, v9 the limit 0,20 statement to the comment!
Use limit in Phpcms get