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