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

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

<?

  $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 todo WHERE oid = %d", $oid);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

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

<form method=post action=update.php3>
<input type=hidden name=type value="todo">
<input type=hidden name=oid value="<? echo $oid; ?>">
<center><table cellpadding=0 cellspacing=1>

<row_input	name=subject
		title="<b>Subject</b>"
		value="<? echo $row['subject']; ?>"
		>
<row_input	name=name
		title="<b>Name</b>"
		value="<? echo $row['name']; ?>"
		>
<row_input	name=email
		title="<b>E-Mail</b>"
		value="<? echo $row['email']; ?>"
		>

<? if ($oid > 0) {
    if (!strlen ($row['done'])) { ?>

<row_radiobox	name=done
		title="<b>Done</b>"
		checked_0="checked"
		checked_1=""
		>

<? } else { ?>

<tr><td align=right bgcolor="<colh>"><font face="Helvetica,Arial"><b>Done</b></font></td>
<td bgcolor="<cold>"><font face="Helvetica,Arial"><?
  $done = explode (" ", $row['done']);
  $done = explode ("-", $done[0]);
  $done = sprintf ("%d.%d.%d", $done[2], $done[1], $done[0]);
  echo $done;
?></font></td></tr>

<? } ?>
<row_radiobox	name=delete
		title="<b>Delete</b>"
		checked_0="checked"
		checked_1=""
		>
<? } ?>

<row_textarea	name=body
		title="<b>Text</b>"
		value="<? echo $row['body']; ?>"
		rows=7
		>

<row_submit>

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

</page>

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