• <tr id='NyfqRR'><strong id='NyfqRR'></strong><small id='NyfqRR'></small><button id='NyfqRR'></button><li id='NyfqRR'><noscript id='NyfqRR'><big id='NyfqRR'></big><dt id='NyfqRR'></dt></noscript></li></tr><ol id='NyfqRR'><option id='NyfqRR'><table id='NyfqRR'><blockquote id='NyfqRR'><tbody id='NyfqRR'></tbody></blockquote></table></option></ol><u id='NyfqRR'></u><kbd id='NyfqRR'><kbd id='NyfqRR'></kbd></kbd>

    <code id='NyfqRR'><strong id='NyfqRR'></strong></code>

    <fieldset id='NyfqRR'></fieldset>
          <span id='NyfqRR'></span>

              <ins id='NyfqRR'></ins>
              <acronym id='NyfqRR'><em id='NyfqRR'></em><td id='NyfqRR'><div id='NyfqRR'></div></td></acronym><address id='NyfqRR'><big id='NyfqRR'><big id='NyfqRR'></big><legend id='NyfqRR'></legend></big></address>

              <i id='NyfqRR'><div id='NyfqRR'><ins id='NyfqRR'></ins></div></i>
              <i id='NyfqRR'></i>
            1. <dl id='NyfqRR'></dl>
              1. <blockquote id='NyfqRR'><q id='NyfqRR'><noscript id='NyfqRR'></noscript><dt id='NyfqRR'></dt></q></blockquote><noframes id='NyfqRR'><i id='NyfqRR'></i>

                SELECT COUNT(product_id) AS SP_COUNTER FROM gsp_product WHERE category_id= or category_id in (1,2,23,66,88,102,103,108,210)
                执行错误: 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 'or category_id in (1,2,23,66,88,102,103,108,210)' at line 1

                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.       返回影◣响行数
                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);
                290.              if(null != $conditions)$where "WHERE ".$conditions;
                291.          }
                292.          $this->pk=isset($this->pk)?$this->pk:"*";
                293.          $sql "SELECT COUNT({$this->pk}) AS SP_COUNTER FROM {$this->tbl_name} {$where}";
                294.          
                295.          $result $this->_db->getArray($sql);
                296.          return $result[0]['SP_COUNTER'];
                297.      }
                298. 
                299.      /**
                300.       魔术函数,执行模型扩展类的自动卐加载及使用
                40.              $this->childlist=$category->findAll(array("parent_id"=>$pid),"","category_id,category_name");
                41.          }
                42.          
                43.          $condition=$category->getIds($cid);
                44.          
                45.          $productcount=$product->findCount($condition);
                46.          $this->productcount=$productcount;
                47.          if($productcount>0)
                48.          {
                49.              $this->productlist=$product->spLinker()->spPager($this->spArgs('page',1),$pagesize)->findAll($condition,"ord desc","product_id,product_name,category_id,product_price,product_pic,product_publisher,product_author");
                50.              
                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);
                24.      ),
                25.  );
                26. 
                27.  require(SP_PATH."/SpeedPHP.php");
                28.  require(SP_PATH."/Extensions/cyFunctions.php");
                29.  spRun();
                30. 
                31.  ?>