#include <infodrom.style>

<page func="Infodrom Oldenburg" title="Events">

<?
  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
	       or die("Unable to connect to SQL server");
?>

<form method=post action=find.php>

<p><b>Keyword</b>: <input name=key size=30 maxsize=60>
<br><b>Year</b>: <select name=year><option value="">-- any year --<?

  $query = "SELECT DISTINCT substr(start::text,0,5) AS year ".
  	   "FROM events ORDER BY substr(start::text,0,5) DESC";

  $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['year'], $row['year']);
  }

?></select>
<br><b>City</b>: <select name=city><option value="">-- any city --<?

  $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['city'], $row['city']);
  }

?></select>
<br><b>Country</b>: <select name=country><option value="">-- any country --<?

  $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 class=button value="Search"> <input type=reset class=button value="Reset"></b></center></p>

</form>

</page>

# Local variables:
# mode: text
# mode: auto-fill
# end: