SAE版分页问题

#1 lainel

我在使用分页函数时出现了一个错误:SELECT COUNT() AS SP_COUNTER FROM d_reply WHERE uid = '1'
执行错误: 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 d_reply WHERE uid = '1'' at line 1

我的代码如下:$autoid=$_SESSION['autoid'];
                $reply=spClass("d_reply");
                $conditions=array("uid"=>"$autoid");
                $fields="qid,content,answer";
                $result1=$reply->spPager($this->spArgs('page',1),10)->findAll($conditions,$fields);
                $this->results=$result1;
                dump($result1);
                $this->pager=$reply->spPager()->getPager();
这是什么原因啊?

2011-06-28 17:34:31

#2 lainel

杯具,我把 Modle中的 $pk 写成了 $key;

2011-06-28 18:20:22