I'm facing a problem:
Here's the code:
/* connection */
$gaSql['user']       = $dbuname;
$gaSql['password']   = $dbpass;
$gaSql['db']         = $dbname;
$gaSql['server']     = $dbhost;
$gaSql['link'] = pg_connect(
    " host=".$gaSql['server'].
    " dbname=".$gaSql['db'].
    " user=".$gaSql['user'].
    " password=".$gaSql['password']
) or die('Could not connect: ' . pg_last_error());
/* query */
$sQuery = "SELECT * FROM person";
$rResult = pg_query( $gaSql['link'], $sQuery ) or die(pg_last_error());
$iTotal = pg_num_rows($rResult);
while ( $aRow = pg_fetch_array($rResult, null, PGSQL_ASSOC) ) {
    //do something...
}
My problem is:
Assumed table person have total 10 rows. The variable $iTotal returned the correct number of rows: 10. But, when I try to fetch it using pg_fetch_array, it cannot fetch (it didn't enter the while operation).
What's wrong with this situation? Please, can anyone help me?
Thank you so much.
