MDB2 Error: Array
| From: | Wing Pui Ma | 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