#1 helloniu

SELECT phome_ecms_news.title, phome_ecms_news.smalltext AS summary, phome_ecms_news_data_1.newstext AS content, phome_ecms_news.classid AS classID, phome_ecms_news.newstime AS date, phome_ecms_news_data_1.befrom AS Source
FROM phome_ecms_news
INNER JOIN phome_ecms_news_data_1 ON phome_ecms_news.id = phome_ecms_news_data_1.id
WHERE phome_ecms_news.classid =35

帝国的数据库   我在phpmyadmin里这句sql就没有问题    一放到php页面就会报错     php页面只能放一些简单的select * from table之类的就不报错

2010-12-22 11:46:48

#2 helloniu

补充    出现问题的是在分页的情况下   不分页就会有问题

2010-12-22 12:04:53

#3 jake

看不到你的出错提示，这里可以建议select后面加上正确的主键。

分页spPager是需要在原本SQL中加入limit和order by语句的，如果执行的SQL是无法加入limit和orderby的话，那么spPager也就没办法了。

2010-12-22 13:03:22