#include <lt2001.style>
#include "edit.style"

<page title="Edit Comment" subtitle=Comments>

<?

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

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

  if ($oid > 0) {
    $query = sprintf ("SELECT * FROM comments WHERE oid = %d", $oid);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
    }
  } else {
    $query = sprintf ("SELECT name FROM project WHERE oid = %d", $project);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
    }
  }
?>

<h3>Comment for <? echo strlen ($row['name'])?$row['name']:$row['project']; ?></h3>

<form method=post action=update.php3>
<input type=hidden name=type value="comment">
<input type=hidden name=oid value="<? echo $oid; ?>">
<input type=hidden name=project value="<? echo $row['name']; ?>">
<center><table cellpadding=0 cellspacing=1>

<row_input	name=who
		title="<b>Name</b>"
		value="<? echo $row['who']; ?>"
		>
<row_input	name=email
		title="<b>E-Mail</b>"
		value="<? echo $row['email']; ?>"
		>
<row_textarea	name=body
		title="<b>Comment</b>"
		value="<? echo $row['body']; ?>"
		rows=7
		>

<row_submit>

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

</page>

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