<form method=post action=find.php3>
<p><b>Keyword</b>: <input name=key size=60 maxsize=60></p>
+<p><b>Country</b>: <select name=country><option value="">-- any country --<?
+
+ $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
+ or die("Unable to connect to SQL server");
+
+ $query = "SELECT DISTINCT country FROM events ORDER BY country";
+
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ $year = 0;
+ for ($i=0; $i < pg_NumRows ($sth); $i++) {
+ $row = pg_fetch_array ($sth, $i);
+ printf ("<option value=\"%s\">%s", $row['country'], $row['country']);
+ }
+
+?></select></p>
<p><center><b><input type=submit value="Search"> <input type=reset value="Reset"></b></center></p>