#include <infodrom.style>

<page func="Infodrom Oldenburg" title="News">

<table class="smallfont border"width=100% cellspacing=1>
<tr class="head"><th width=5%>Nr.</th>\
<th width=15%>Autor</th>\
<th width=70%>Titel</th>\
<th width=10%>Datum</th></tr>

<?
  $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 = "SELECT id,subject,author,releasedate,deleted FROM news ORDER BY releasedate DESC,insertd DESC";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  $color = 0;
  for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
    $row = pg_fetch_array ($sth, $nr);
    $date = explode (" ", $row['releasedate']);
    $date = explode ("-", $date[0]);
    $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);

    printf ("<tr class=\"t%d\"><td>%d</td>", $color, $nr+1);
    if ($row['deleted'] == 1) {
      $del = " (del)";
    } else {
      $del = "";
    }
    printf ("<td class=\"leftcol\">%s</td><td><a href=\"edit.php?id=%d\">%s</a>%s</td><td align=\"right\" class=\"rightcol\">%s</td></tr>",
	   $row['author'], $row['id'], $row['subject'], $del, $date);
    $color = !$color;
  }
?>

</table>

<div style="padding-top: 5px;"></div>

</page>

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