[fw-general] [fw-db] Zend_Db (mysqli adapter) fetch nested queries

[Vladas Diržys]

Hello guys,

if I try to fetch nested queries it looks so, that it doesn't work properly.
It closes first statement on creating another one.
This is not a case with pdo_mysql adapter.

Code example:
        if ($result = $db->query("SELECT * FROM some_table LIMIT 10")) {
            while ($row = $result->fetch()) {
                *print_r($row);*
                if ($_result = $db->query("SELECT * FROM some_table LIMIT
5")) {
                    while ($_row = $_result->fetch()) {
                        *print_r($_row);*
                    }
                    $_result->close();
                }
            }
            $result->close();
        }

This prints only 1+5 results instead of 10*5.

Is this behaviour a bug, or undocumented feature? :-)

-- 
Pagarbiai // Gruß,
Vladas Diržys
tel.: +370 620 69020 (Omnitel)
+370 677 17851 (Tele2)
www.dirzys.com