<html>
<body>
<?php

$conn = pg_Connect("host=localhost dbname=mag user=dags");
if (!$conn) {
    echo "No me pude conectar <br>\n";
    exit;
} else {
    echo " <br> \n";
}

$result = pg_Exec($conn,"SELECT account_id, account_name, currency_id FROM accounts ORDER BY account_id");

if (!$result) {
    echo "No pude leer<br>\n";
    exit;
} else {
    echo " <br>\n";
}

$num = pg_numrows($result);
        echo "\n $num Registros <BR> \n";

echo "<TABLE align=\"CENTER\" border=\"1\"width = \"80%\" >\n";
echo "<CAPTION><EM>Cuentas Contables</EM></CAPTION>\n";

        echo "<TR><TH>Cuenta<TH>Denominacion<TH>Moneda\n";
for ($i=0; $i < $num;  $i++) {

    $r = pg_fetch_row($result, $i);

    echo "<TR>";
    for ($j=0; $j<count($r); $j++) {
        echo "<TD>";
        echo "$r[$j] &nbsp;";
    }
    echo "<BR>\n";
}
echo "</TABLE>";
?>
</body>
</html>
