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

<page title="Edit Appendix" subtitle=Appendix>

<?

  $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 = 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);

    $query = sprintf ("SELECT oid,project,boothtitle,description,description_en FROM appendix WHERE project = '%s'", $row['name']);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
    } else {
      $row['project'] = $row['name'];
    }
?>

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

<row_input	name=boothtitle
		title="<b>Booth title</b>"
		value="<? echo $row['boothtitle']; ?>"
		>

<row_textarea	name=description
		title="<b>Kurzbeschreibung</b>"
		value="<? echo $row['description']; ?>"
		rows=4
		>

<row_textarea	name=description_en
		title="<b>Short description</b>"
		value="<? echo $row['description_en']; ?>"
		rows=4
		>

<? if ($oid > 0) { ?>
<row_radiobox	name=delete
		title="<b>Delete</b>"
		checked_0="checked"
		checked_1=""
		>
<? } ?>

<row_submit>

</table></center></form>
<?
  }
?>

</page>

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