#include <infodrom.style>

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

<?
  if ($_GET[id] > 0) {
    $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
		 or die("Unable to connect to SQL server");

    pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");

    $query = "SELECT * FROM patches WHERE oid = '$_GET[id]'";
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
    }
#  } else {
#    $row['submitted'] = date ("Y-m-j H:i");
  }
?>

<p>
<form method=post action="update.php">
<input type=hidden name=id value="<? echo $_GET[id]; ?>">
<b>Package:</b> <input name=package size=60 maxlength=120 value="<? echo $row['package']; ?>"><br>
<b>Version:</b> <input name=version size=60 maxlength=120 value="<? echo $row['version']; ?>"><br>
<b>Subject:</b> <input name=subject size=60 maxlength=120 value="<? echo $row['subject']; ?>"><br>
<b>Text:</b> <br><textarea name=description rows=7 cols=67><? echo $row['description']; ?></textarea><p>
<b>Download:</b> <br><textarea name=download rows=5 cols=67><? echo $row['download']; ?></textarea><p>

<? if ($_GET[id] > 0) { ?>
<b>Delete:</b> <input name=delete type=radio value="1"> yes
<input name=delete type=radio value="0" checked> no<br>
<? } ?>
<p><center><input class button type=submit value="<? echo $_GET[id]>0?"Update":"Insert"; ?>"> <input class=button type=Reset></center><p>
</form>

</page>

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