SELECT * FROM sp_article_cat WHERE id= ORDER BY id LIMIT 1<br />执行错误: 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 'ORDER BY id LIMIT 1' at line 1

SELECT * FROM sp_article_cat WHERE id= ORDER BY id LIMIT 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 'ORDER BY id LIMIT 1' at line 1

Deprecated: Function ereg() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 56 Deprecated: Function ereg_replace() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 59 Deprecated: Function ereg() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 56 Deprecated: Function ereg_replace() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 59 Deprecated: Function ereg() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 56 Deprecated: Function ereg_replace() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 59 Deprecated: Function ereg() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 56 Deprecated: Function ereg_replace() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 59 Deprecated: Function ereg() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 56 Deprecated: Function ereg_replace() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 59 Deprecated: Function ereg() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 56 Deprecated: Function ereg_replace() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 59 Deprecated: Function ereg() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 56 Deprecated: Function ereg_replace() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 59 Deprecated: Function ereg() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 56 Deprecated: Function ereg_replace() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 59 Deprecated: Function ereg() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 56 Deprecated: Function ereg_replace() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 59 Deprecated: Function ereg() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 56 Deprecated: Function ereg_replace() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 59 Deprecated: Function ereg() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 56 Deprecated: Function ereg_replace() is deprecated in /home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Misc/notice.php on line 59

/home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Drivers/mysql.php on line 62

57.

58.


        $this->arrSql[] = $sql;

59.


        if( $result = mysql_query($sql, $this->conn) ){

60.


            return $result;

61.


        }else{

62.


            spError("{$sql}<br />执行错误: " . mysql_error());

63.

64.

65.

66.

/**

67.


     * 返回影响行数

/home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Drivers/mysql.php on line 26

21.

22.


     * @param sql  执行的SQL语句

23.

*/

24.


    public function getArray($sql)

25.

26.


        if( ! $result = $this->exec($sql) )return FALSE;

27.


        if( ! mysql_num_rows($result) )return FALSE;

28.


        $rows = array();

29.


        while($rows[] = mysql_fetch_array($result,MYSQL_ASSOC)){}

30.


        mysql_free_result($result);

31.


        array_pop($rows);

/home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Core/spModel.php on line 121

116.


        }else{

117.


            $sort = "ORDER BY {$this->pk}";

118.

119.


        $sql = "SELECT {$fields} FROM {$this->tbl_name} {$where} {$sort}";

120.


        if(null != $limit)$sql = $this->_db->setlimit($sql, $limit);

121.


        return $this->_db->getArray($sql);

122.

123.

/**

124.


     * 过滤转义字符

125.

126.


     * @param value 需要进行过滤的值

/home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/Core/spModel.php on line 83

78.


     * @param sort    排序，等同于“ORDER BY ”

79.


     * @param fields    返回的字段范围，默认为返回全部字段的值

80.

*/

81.


    public function find($conditions = null, $sort = null, $fields = null)

82.

83.


        if( $record = $this->findAll($conditions, $sort, $fields, 1) ){

84.


            return array_pop($record);

85.


        }else{

86.


            return FALSE;

87.

88.

/home/gzrb0076gezjr1bm070s7/wwwroot/modules/index/news.php on line 19

14.


            $sql="SELECT a.*,b.catename FROM sp_article a LEFT JOIN sp_article_cat b ON a.pid=b.id WHERE a.pid=2 AND is_open =1 ORDER BY id desc";

15.


        }else{

16.


            $sql="SELECT * FROM sp_article WHERE pid=".$_GET['pid']. " ORDER BY id desc";

17.


            $detail         = spClass('article_cat')->find("id=".$_GET['pid']);

18.


            $this->detail   = $detail;

19.


            $this->pcate    = spClass('article_cat')->find("id=".$detail['pid']);

20.

21.

22.


        $this->rows     = spClass('article_list')->spPager($this->spArgs('page', 1), 20)->findSql($sql);

23.


/*        print_r($rows['catename']);

24.


        exit();*/

/home/gzrb0076gezjr1bm070s7/wwwroot/SpeedPHP/spFunctions.php on line 21

16.


//    if(!is_object($handle_controller) || !method_exists($handle_controller, $__action)){

17.


//        eval($GLOBALS['G_SP']["dispatcher_error"]);

18.


//        exit;

19.


//    }

20.


    // 路由并执行用户代码

21.


    $handle_controller->$__action();

22.


    // 控制器程序运行完毕，进行模板的自动输出

23.


    if(FALSE != $GLOBALS['G_SP']['view']['auto_display']){

24.


        $__tplname = $__controller.$GLOBALS['G_SP']['view']['auto_display_sep'].

25.


                $__action.$GLOBALS['G_SP']['view']['auto_display_suffix']; // 拼装模板路径

26.


        $handle_controller->auto_display($__tplname);

/home/gzrb0076gezjr1bm070s7/wwwroot/index.php on line 16

11.


$spConfig['controller_path'] = APP_PATH.'/modules/'.basename(__FILE__,".php");

12.


define("APP_PATH",dirname(__FILE__)); // 这是入口文件原有的

13.


define("PATH_ROOT","http://localhost/gemro/www");

14.


// 载入SpeedPHP框架

15.


require(SP_PATH."/SpeedPHP.php");

16.


spRun(); // SpeedPHP 3新特性

SELECT * FROM sp_article_cat WHERE id= ORDER BY id LIMIT 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 'ORDER BY id LIMIT 1' at line 1

SELECT * FROM sp_article_cat WHERE id= ORDER BY id LIMIT 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 'ORDER BY id LIMIT 1' at line 1