Php > Databases

Function Query2Array will read an PEAR-DB-Query-Result into an Array

Function Query2Array will read an PEAR-DB-Query-Result into an Array

<?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; 
    } 
?>