MDB2 Error: Array

From: Date: Sun, 01 Oct 2006 07:50:07 +0000
Subject: MDB2 Error: Array
Groups: php.pear.dev 
Request: Send a blank email to pear-dev+get-44222@lists.php.net to get a copy of this message
Dear Pear support, Hello! I tried this code: <?php
    require_once("MDB2.php");
    $linkm =& MDB2::connect("mysqli://".$db_username.":".$db_password."@".$db_host."/".$db_schema."");
    if(MDB2::isError($linkm)){
printf("Connect failed: %s\n", $linkm->getMessage()); die("Connection Failed\n");
    }
for($i=0; $i<100; $i++){ $sql = "call list_city()"; $result =& $linkm->query($sql); if(MDB2::isError($result)){ die($result->getMessage()); } while($row =& $result->fetchRow()){ } $result->free(); $sql = "call list_country()"; $result =& $linkm->query($sql); if(MDB2::isError($result)){ die($result->getMessage()); } while($row =& $result->fetchRow()){ } $result->free(); $sql = "call list_state()"; $result =& $linkm->query($sql); if(MDB2::isError($result)){ die($result->getMessage()); } while($row =& $result->fetchRow()){ } $result->free(); $sql = "call list_name()"; $result =& $linkm->query($sql); if(MDB2::isError($result)){ die($result->getMessage()); } while($row =& $result->fetchRow()){ } $result->free(); $sql = "call list_postcode()"; $result =& $linkm->query($sql); if(MDB2::isError($result)){ die($result->getMessage()); } while($row =& $result->fetchRow()){ } $result->free(); $sql = "call list_tel()"; $result =& $linkm->query($sql); if(MDB2::isError($result)){ die($result->getMessage()); } while($row =& $result->fetchRow()){ } $result->free(); $sql = "call list_mobile()"; $result =& $linkm->query($sql); if(MDB2::isError($result)){ die($result->getMessage()); } while($row =& $result->fetchRow()){ } $result->free();
       }
       print "finish<br>";
?> Sometime it print out the "finish", sometime it print out the error message "MDB2 Error: Array". I really don't know why? Is the peal have a problem? It is just a simple "list" procedure! If use pear to run more procedures, error will happen more! I am looking forward to your help! Thanks! Best regards, Vincent

« previous php.pear.dev (#44222) next »