SELECT COUNT(id) AS SP_COUNTER FROM my_product WHERE id>0 and classid1=index.php <br />执行错误: Unknown column 'index.php' in 'where clause'

SELECT COUNT(id) AS SP_COUNTER FROM my_product WHERE id>0 and classid1=index.php
执行错误: Unknown column 'index.php' in 'where clause'

Deprecated: Function ereg() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/chxyq.com/SpeedPHP/Misc/notice.php on line 54

/www/wwwroot/chxyq.com/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.


     * 返回影响行数

/www/wwwroot/chxyq.com/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 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);

/www/wwwroot/chxyq.com/SpeedPHP/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.


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

/www/wwwroot/chxyq.com/modules/home/product.php on line 23

18.


        if($cid1){

19.


            $where.=" and classid1=$cid1 ";

20.

21.


        //echo $where;

22.


        $rs=spClass("m_product");

23.


        $total=$rs->findCount($where);

24.


        $pagesize=8;

25.


        $res=$rs->spLinker()->spPager($this->spArgs("page",1),$pagesize)->findAll($where,"px desc,id desc");

26.


        $pager=new pager($total, $pagesize, $this->spArgs("page",1));

27.


        $this->res=$res;

28.


        $this->total=$total;

/www/wwwroot/chxyq.com/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);

/www/wwwroot/chxyq.com/index.php on line 48

43.

),

44.

);

45.

*/

46.

47.


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

48.


spRun();

SELECT COUNT(id) AS SP_COUNTER FROM my_product WHERE id>0 and classid1=index.php 执行错误: Unknown column 'index.php' in 'where clause'

SELECT COUNT(id) AS SP_COUNTER FROM my_product WHERE id>0 and classid1=index.php
执行错误: Unknown column 'index.php' in 'where clause'