<form method=post action=find.php3>
<p><b>Keyword</b>: <input name=key size=60 maxsize=60>
-<p><b>Year</b>: <input name=year size=60 maxsize=10>
-<br><b>Country</b>: <select name=country><option value="">-- any country --<?
+<br><b>Year</b>: <input name=year size=60 maxsize=10>
+<br><b>City</b>: <select name=city><option value="">-- any city --<?
$dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
or die("Unable to connect to SQL server");
- $query = "SELECT DISTINCT country FROM events ORDER BY country";
+ $query = "SELECT DISTINCT city FROM events ORDER BY city";
$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']);
+ printf ("<option value=\"%s\">%s", $row['city'], $row['city']);
}
-?></select></p>
-
-<br><b>City</b>: <select name=city><option value="">-- any city --<?
+?></select>
+<br><b>Country</b>: <select name=country><option value="">-- any country --<?
$dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
or die("Unable to connect to SQL server");