Mega Code Archive
Function Query2Array will read an PEAR-DB-Query-Result into an Array
<![CDATA[
<?php
require_once("DB.php");
function Query2Array ( $result, $keyColumn = NULL, $skipRows = 0, $fetchRows = -
1 ) {
$retval = array();
if ( $skipRows >= $result->numRows() ) $skipRows = 0;
for ( $i = 1; $i <= $skipRows; $i++) $result->fetchRow();
$Rows = $result->numRows() - $skipRows;
if ( $fetchRows >= 0) $Rows = Min($Rows, $fetchRows);
$fetchRows = $Rows;
for ($i = 0; $i < $fetchRows; $i++ ) {
$row = $result->fetchRow();
if ( is_string($keyColumn) ) $retval[$row[$keyColumn]] = $row;
else $retval[] = $row;
}
return $retval;
}
?>
]]>