#1 msggo

一句简单的查询就出错了：  
  $internet_bar = spClass("internet_bar");
  $this->results = $internet_bar->spPager($this->spArgs('page', 1), 30)->findSql("select internet_bar.* from internet_bar;");
  
报错：
SELECT COUNT(uid) as sp_counter FROM (select internet_bar.* from internet_bar;) 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 ';) sp_tmp_table_pager1' at line 1

补充内容 (2012-2-16 18:58):
应该是SQL语句末尾不能带;的问题。

2012-02-16 18:44:07

#2 jake

因为php默认的mysql的query函数就不能执行多条sql语句，所以SQL带上分号会出错！

2012-02-17 00:14:23