Can't return a result set in the given context

php zend-framework mysqli multi-select
Farid picture Farid · Jul 29, 2009 · Viewed 18.2k times · Source

When ever I try to call store procedure in mysql that sends back a result set, it keeps saying me that "can't return a result set in the given context".

I've google it and some said it's mysql bug, some said you should change your mysqli driver and ....

Situation :

Using mysqli driver Client API library version 5.0.51a , PHP Version 5.2.4-2ubuntu5.6, Using Zend 1.9 RC 1 Mysqli adapter.

What should I do!?

Answer

Farid picture Farid · Jul 30, 2009

The answer is to upgrade your php, I've just upgraded mine to 5.3.0, and it's works likes Candy!

Related questions

how to create virtual host on XAMPP

I am sure this question is being asked many times but I am not encounter with a problem. I am using XAMPP where I configure Zend framework. XAMPP is running on port 8081 as 80 is being occupied by some Windows process …

Read More
php, mysql - Too many connections to database error

Good day to all. I have an odd error. I have created a chat that works like this: questions/answers are inserted into a db every 2 seconds an ajax request is sent to a php script that fetch the new …

Read More
PHP - cannot use a scalar as an array warning

I have the following code: $final = array(); foreach ($words as $word) { $query = "SELECT Something"; $result = $this->_db->fetchAll($query, "%".$word."%"); foreach ($result as $row) { $id = $row['page_id']; if (!empty($final[$id][0])) { $final[$id][0] = $final[$id][0]+3; } else { $final[$…

Read More