$database= pg_Connect ("", "", "", "", "vyuka");
$vystup = pg_Exec($database, "SELECT k.nazev, k.autor, v.jmeno FROM vypujcky v, knihy k WHERE v.jmeno='Huzva' AND v.index=k.index ORDER BY v.jmeno");
$pocet = pg_NumRows($vystup);
printf("%-10s %-10s %-10s\n", "Kdo", "Název", "Autor");
echo "==================================\n";
$i = 0;
while ($i < $pocet ) {
$radek = pg_Fetch_Array($vystup, $i);
printf("%-10s %-10s %-10s\n", $radek["jmeno"], $radek["nazev"], $radek["autor"]);
$i++;
}
?>