所有字段:select count(*) as total from phome_ecms_news where classid=1 and checked=1
说明:关键词(keyboard)北京的信息调用出来
统计总共有多少条信息:select count(*) as total from [!db.pre!]ecms_news where checked=1 and
keyboard like '%北京%'
查询总共有多少条记录:select * from [!db.pre!]ecms_news where checked=1 and keyboard like '%北
京%' order by newstime desc
显示结果举例:
http://www.imtoday.cn/news/hubei/
http://www.imtoday.cn/news/sichuan/
http://www.imtoday.cn/news/hunan/
http://www.imtoday.cn/news/fuj