1 #include <infodrom.style>
4 <page title="Infodrom Oldenburg - Todo">
6 <h1 align=center><font face="Helvetica,Arial">Infodrom Oldenburg</font></h1>
7 <h3 align=center><font face="Helvetica,Arial">- Outstanding jobs -</font></h3>
11 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
12 or die("Unable to connect to SQL server");
14 pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
16 $query = "SELECT package,submitted,description FROM todo WHERE done IS NULL ORDER by package,submitted";
17 $sth = pg_exec ($dbh, $query); // or die("Datenbank-Abfrage!");
20 for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
21 $row = pg_fetch_array ($sth, $nr);
22 $date = explode (" ", $row['submitted']);
23 $date = explode ("-", $date[0]);
24 $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
26 if ($package != $row['package']) {
27 printf ("<h3><font face=\"Helvetica,Arial\">%s</font></h3>", $row['package']);
28 $package = $row['package'];
32 <border color=<box-bdcolor>>
34 <table width=100% border=0 cellpadding=1 cellspacing=0>
36 <th width=90% align=left><font face="Helvetica,Arial"><b><? echo $row['subject']; ?></b></font></t>
37 <th width=10% align=right><font face="Helvetica,Arial"><? echo $date; ?></font></th>
41 <td colspan=2 width=100%><font face="Helvetica,Arial"><? echo $row['description']; ?></font></td>