帝国CMS自定义列表查询SQL语句,怎么从第N条开始查询

帝国教程 强烈建议 2024-03-04 08:42 132 0

  统计记录:select count(*) as total from [!db.pre!]ecms_news where id>(select id from [!db.pre!]ecms_news order by id desc limit 10,1) and checked=1

查询记录:select * from phome_ecms_news where checked=1 order by newstime desc

本站资源均来自互联网或会员发布,如果不小心侵犯了您的权益请与我们联系。我们将立即删除!谢谢!