comarques.php

<!DOCTYPE html>
<HTML>
<HEAD>
<meta charset="UTF-8">
<TITLE> APACHE - PHP - POSTGRESQL </TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<?php

$bd=pg_Connect("host=localhost dbname=geo user=geo password=geo");
$rs1=pg_query($bd,"SELECT * FROM COMARQUES ORDER BY nom_c");

echo "<table border=1>";
echo "<tr><th>nom</th><th>província</th></tr>";

while ($f=pg_fetch_row($rs1))
    echo "<tr><td>$f[0]</td><td>$f[1]</td></tr>";

echo "</table>";
?>
</BODY>
</HTML>