Commands out of sync

Hack:

/system/database/drivers/mysqli/mysqli_result.php

CodeIgniter does not currently allow more than one stored procedure to be run during the same request.

The following method was added to the CI_DB_mysqli_result class:

Code:

/**
* Read the next result
*
* @return  null
*/  
function next_result()
{
    if (is_object($this->conn_id))
    {
        return mysqli_next_result($this->conn_id);
    }
}

// --------------------------------------------------------------------

Then you simply call next_result() between calls to your stored procedures. This assumes you're using MySQLi.

i have done this but still facing same problem

here is my retrieving data code

foreach($result->next_result() as $values){ }