SELECT COUNT(id) AS SP_COUNTER FROM qf_self WHERE Array and visible = 1 <br />执行错误: Unknown column 'Array' in 'where clause'

SELECT COUNT(id) AS SP_COUNTER FROM qf_self WHERE Array and visible = 1
执行错误: Unknown column 'Array' in 'where clause'

/home/hljt/domains/www.spirittaco.com/public_html/en/Comm/MyFrame/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/hljt/domains/www.spirittaco.com/public_html/en/Comm/MyFrame/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 array();

27.


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

28.


        $rows = array();

29.


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

30.


        mysql_free_result($result);

31.


        array_pop($rows);

/home/hljt/domains/www.spirittaco.com/public_html/en/Comm/MyFrame/Core/spModel.php on line 257

252.


            $where = "WHERE ".join(" AND ",$join);

253.


        }else{

254.


            if(null != $conditions)$where = "WHERE ".$conditions;

255.

256.


        $sql = "SELECT COUNT({$this->pk}) AS SP_COUNTER FROM {$this->tbl_name} {$where}";

257.


        $result = $this->_db->getArray($sql);

258.


        return $result[0]['SP_COUNTER'];

259.

260.

261.

/**

262.


     * 魔术函数，执行模型扩展类的自动加载及使用

/home/hljt/domains/www.spirittaco.com/public_html/en/Comm/MyFrame/Core/spModel.php on line 438

433.


        $pageSize = $this->input_args[1];

434.


        @list($conditions, $sort, $fields ) = $func_args;

435.


        if('findSql'==$func_name){

436.


            $total_count = array_pop( array_pop( $this->model_obj->findSql("SELECT COUNT({$this->model_obj->pk}) as sp_counter FROM ($conditions) sp_tmp_table_pager1") ) );

437.


        }else{

438.


            $total_count = $this->model_obj->findCount($conditions);

439.

440.


        if($total_count > $pageSize){

441.


            $total_page = ceil( $total_count / $pageSize );

442.


            $page = min(intval(max($page, 1)), $total_count); // 对页码进行规范运算

443.


            $this->pageData = array(

/home/hljt/domains/www.spirittaco.com/public_html/en/Comm/MyFrame/Core/spModel.php on line 413

408.

/**

409.


     * 魔术函数，支持多重函数式使用类的方法

410.

*/

411.


    public function __call($func_name, $func_args){

412.


        if( ( 'findAll' == $func_name || 'findSql' == $func_name ) && 0 != $this->input_args[0]){

413.


            return $this->runpager($func_name, $func_args);

414.


        }elseif(method_exists($this,$func_name)){

415.


            return call_user_func_array(array($this, $func_name), $func_args);

416.


        }else{

417.


            return call_user_func_array(array($this->model_obj, $func_name), $func_args);

418.

/home/hljt/domains/www.spirittaco.com/public_html/en/Action/home.php on line 970

965.


        //页码数

966.


        $pages = $this->spArgs('page', 1);

967.


        //每页显示记录数

968.


        $pagenum = 6;

969.


        //列表

970.


        $this->list = $obj_self->spPager($pages, $pagenum)->findAll($condition_self,'orders DESC,id DESC');

971.


        //分页数据

972.


        $pager = $obj_self->spPager()->getPager();

973.


        //导入自定义分页类

974.


        import('rewritepage.class.php');

975.


        //实例化分页

/home/hljt/domains/www.spirittaco.com/public_html/en/Action/home.php on line 970