Command out of sync

[eluser]Yauhen_S[/eluser]
Hi! I was solve this problem in other way. Below is a _execute method code:

Code:

// Free result from previous query
   @mysqli_free_result($this->result_id);
        
   $sql = $this->_prep_query($sql);

   // get a result code of query (), can be used for test is the query ok
   $retval = @mysqli_multi_query($this->conn_id, $sql);

   // get a first resultset
   $firstResult = @mysqli_store_result($this->conn_id);

   // free other resultsets
   while (@mysqli_next_result($this->conn_id)) {
      $result = @mysqli_store_result($this->conn_id);
      @mysqli_free_result($result);
   }

   // test is the error occur or not
   if (!$firstResult && !@mysqli_errno($this->conn_id)) {
       return true;
   }
   return $firstResult;

About check for error in last lines. This is because mysqli_store_result can return false not only if error occur, but also if query don't return resultset. Unfortunately CI checks only returned value for false and in this case "Error Number: 0" occures.

PS: I'm not sure that this will works with regular query, i'm using only stored routines in my current project.