由于使用select * from pcms_news where title like "%活动%" group by title order by listorder desc这样的语句进行get查询不能统计出查询的所有结果总和,所以页面不能显示pages分页栏。
而要查询group by分组后的结果总和,必须用如下方法
select count(*) as count from (select * from pcms_news where title like "%活动%" group by title order by listorder desc) temp
所以,解决此问题最好的方式就是在数据库中直接创建一个视图viewtemp
视图查询语句为select * from pcms_news where title like "%活动%" group by title order by listorder desc
然后在模板里直接查询这个viewtemp视图就可以了
select * from viewtemp order by listorder desc