<page func="Infodrom Oldenburg" title="Logbook">
<form method=post action=find.php3>
+<b>Keyword:</b> <input name=keyword size=30 maxlength=80><br>
<b>Category:</b> <select name=category><option value="">any<?
$dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
or die("Unable to connect to SQL server");
- pg_exec ($dbh, "SELECT DISTINCT category FROM logbook ORDER BY category") or die("Datenbank-Abfrage!");
+ $sth = pg_exec ($dbh, "SELECT DISTINCT category FROM logbook ORDER BY category") or die("Datenbank-Abfrage!");
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
$srow = pg_fetch_array ($sth, $nr);
printf ("<option value=\"%s\"%s>%s\n", $srow['category'],
$row['category'] == $srow['category']?" selected":ยจ, $srow['category']);
}
?></select>
-<b>Keyword:</b> <input name=keyword size=30 maxlength=80><br>
<p><center><input type=submit value="Search">\