title: Codeigniter Call to a member function row() on bool when using stored procedure in mysql
body: <p>I am trying to get a result set from a stored procedure using codeigniter in order to shorten the amount of call in my models.</p>
  <p><strong>MYSQL Stored Proc</strong></p>
  <pre><code>CREATE DEFINER=`dbsdecks_mark`@`97.119.%` PROCEDURE `all_cards`()
  BEGIN
    -- drop the temporary table for clean up
      DROP TEMPORARY TABLE IF EXISTS cardList;
  
      -- create temporary table holding unique product ids, card numbers, and group ids for one of each card in the game no reprints or duplicates
      CREATE TEMPORARY TABLE cardList
      Select DISTINCT 
     `Number` as cardNumber, 
          MIN(productId) as productId,
          MIN(groupId) as groupId
      from tcgplayer_card
      Where `Rarity` NOT IN ('None', 'Special Rare', 'Merit', 'Token') AND `Number` NOT IN ('0') 
      and regexp_like(`Number`,'^[A-Z0-9]{0,4}-[A-Z0-9]{0,3}$')
      GROUP BY `Number`
      ORDER BY `Number`;
      
      -- select the master list based off of that temporary table
      SELECT 
      cl.*,
      `tcg`.`Rarity` as rarity,
      `tcg`.`Description` as cardText,
      `tcg`.`CardType` as cardType,
      `tcg`.`Color` as color,
      `tcg`.`EnergyColorCost` as energyCost,
      `tcg`.`SpecialTrait` as specialTrait,
      `tcg`.`Power` as power,
      `tcg`.`ComboPower` as comboPower,
      `tcg`.`ComboEnergy` as comboEnergy,
      `tcg`.`Era` as era,
      `tcg`.`Character` as cardCharacter,
      tcg.url,
      tcg.imageUrl
      from cardList cl
      INNER JOIN tcgplayer_card tcg ON cl.productId = tcg.productId;
  END
  </code></pre>
  <p><strong>CI function</strong></p>
  <pre><code>public function get_all_cards() {
      $query = $this-&gt;db-&gt;query(&quot;CALL ALL_CARDS&quot;);
      return $query-&gt;result();
  }
  </code></pre>
  <p>By all accounts I am doing things correctly. Here is the error that I am getting thrown</p>
  <p><code>PHP Fatal error:  Uncaught Error: Call to a member function row() on bool in C:\inetpub\wwwroot\api\system\libraries\Session\drivers\Session_database_driver.php:399</code></p>