#include <lt2001.style>

<page title="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);

      $date = explode (" ", $row['date']);
      $date = explode ("-", $date[0]);
      $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);

      if (strlen ($row['done'])) {
        $done = explode (" ", $row['done']);
        $done = explode ("-", $done[0]);
        $done = sprintf ("%d.%d.%d", $done[2], $done[1], $done[0]);
      }

    } else {
      die ("No id given");
    }
  }
?>


<h3><? echo $row['subject']; ?></h3>

<p>Submitted by: <? echo $row['who']; ?>
<br>Submitted at: <? echo $date; ?>
<? if (strlen ($row['done'])) { ?>
<br>Done at: <? echo $done; ?>
<? } ?>

<blockquote>
<? echo $row['body']; ?>
</blockquote>

<center><a href="edit_todo.php3?oid=<? echo $oid; ?>">Edit</a></center>

</page>

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