#include <infodrom.style>
<define-tag linxcold>e6e8fa</define-tag>
<define-tag inputsize>60</define-tag>

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

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

  $query = "SELECT oid,url,subject,category,keywords FROM links WHERE oid = $_GET[oid]";
  $sth = pg_exec ($dbh, $query);

  if (pg_NumRows ($sth) > 0) {
    $row = pg_fetch_array ($sth, 0);
    $row['subject'] = ereg_replace ("\"", "&quot;", $row['subject']);
?>

<h3>URL: <? echo $row['url']; ?></h3>

<form method="post" action="update.php">
<input type=hidden name=oid value="<? echo $row['oid']; ?>">
<center>
<table class="font border" cellspacing="0" cellpadding="2" width="90%" bgcolor="#<linxcold>" >

<tr>
<td align="right" width="20%"><font face="Helvetica,Arial">&nbsp;URL</font></td>
<td width="80%"><font face="Helvetica,Arial">&nbsp;<input type=text size=<inputsize> maxlength=100 value="<? echo $row['url']; ?>" name="url"></font></td>
</tr>

<tr>
<td align="right" width="20%"><font face="Helvetica,Arial">&nbsp;Subject</font></td>
<td width="80%"><font face="Helvetica,Arial">&nbsp;<input type=text size=<inputsize> maxlength=100 value="<? echo $row['subject']; ?>" name="subject"></font></td>
</tr>

<tr>
<td align="right" width="20%"><font face="Helvetica,Arial">&nbsp;Category</font></td>
<td width="80%"><font face="Helvetica,Arial">&nbsp;<input type=text size=<inputsize> maxlength=64 value="<? echo $row['category']; ?>" name="category"></font></td>
</tr>

<tr>
<td align="right" width="20%"><font face="Helvetica,Arial">&nbsp;Keywords</font></td>
<td width="80%"><font face="Helvetica,Arial">&nbsp;<input type=text size=<inputsize> maxlength=200 value="<? echo $row['keywords']; ?>" name="keywords"></font></td>
</tr>

<tr>
<td align="right" width="20%"><font face="Helvetica,Arial">&nbsp;Delete</font></td>
<td width="80%"><font face="Helvetica,Arial">&nbsp;<input type=checkbox value=1 name="delete"></font></td>
</tr>

<tr>
<td colspan="2" align="center"><font face="Helvetica,Arial"></font>
<center><font face="Helvetica,Arial"><input class="button" type="submit" value="Update"> &nbsp; <input type="reset" class="button" value="Reset"></font></center>
</td>
</tr>

</table>
</center>
</form><p>

<? } else { ?>

?>

<p><b>Nothing found.</b><p>

<? } ?>

</page>

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