Welcome Guest, Not a member yet? Register   Sign In
Stored Procedures

I am trying to use stored procedures and CI together. When I call the command through terminal, I get the result

mysql> call moo();
|   user_id |
|         1 |
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

But when I run this

$query = $this->db->query('call moo();');
print_r ( $query->result_array( ) );

I get the following error

Quote:<h1>A Database Error Occurred</h1>
<p>Error Number: 1312</p><p>PROCEDURE users.moo can't return a result set in the given context</p><p>call moo();</p>

Any ideas how to fix this?


Changed from mysql to mysqli = problems over.

Theme © iAndrew 2016 - Forum software by © MyBB