我用站点提供的工具得到的get标签:
{get sql="SELECT `catid`,`title`,`thumb`,`description`,`url`,`updatetime` FROM `phpcms_content` WHERE `catid` = '$catid' ORDER BY `updatetime` DESC" rows="6" page="$page" }
{$r[catid]}
{$r[title]}
{$r[thumb]}
{$r[description]}
{$r[url]}
{$r[updatetime]}
{/get}
{$pages}
生成后分页部分出现sql错误
后来自己写了个标签的开头部分:
{get sql="SELECT contentid,catid,title,style,thumb,keywords,description,userid,updatetime,islink,inputtime,url FROM `phpcms_content` WHERE status=99 AND `catid` IN(31,32) ORDER BY contentid DESC" rows="6" page="$page"catid="$catid"}
生成后分页正常.不知道为什么......