#1 y1ba

我的代码如下：

$renew = spClass("p")->spLinker()->spPager($this->spArgs('page', 1), 20)->findSql("SELECT title,id,uid FROM p WHERE uid in(SELECT uid FORM u WHERE mediaUserID=".$_COOKIE["mid"].") GROUP BY id desc");  

运行后出现错误：

SELECT COUNT() as sp_counter FROM (SELECT title,id,uid FROM p WHERE uid in(SELECT uid FORM u WHERE mediaUserID=1348772) GROUP BY id desc) sp_tmp_table_pager1
执行错误: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') as sp_counter FROM (SELECT title,id,uid FROM p WHERE uid in(SELECT uid FORM u ' at line 1

2012-06-16 17:18:07

#2 jake

要设置主键！

2012-06-16 19:26:16

#3 y1ba

有主键呀，我是想 查询分页，多个分类下面的全部文章，这个要怎么弄？

2012-06-20 11:28:05

#4 jake

看手册，有教程

2012-06-20 14:50:33