#include <infodrom.style>
#include "zeitungen.inc"

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

<listform>

<infodromlink>

<?
  $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 oid,url,name,city,changed FROM zeitungen WHERE deleted IS NULL";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  $num = pg_NumRows ($sth);
  if ($num > 0) {
    echo ('<h3 class="bar">Nicht bestätigte Zeitungen</h3>');
    echo ('<ul>');
    for ($nr=0; $nr < $num; $nr++) {
      $row = pg_fetch_array ($sth, $nr);
      printf ('<li><a href="%s">%s</a>, %s '.
	      '<a href="update.php?approve=%d">akzeptieren</a> '.
	      '<a href="update.php?delete=%d">löschen</a></li>',
	      $row['url'],
	      $row['name'],
	      $row['city'],
	      $row['oid'],
	      $row['oid']);
    }
    echo ('</ul>');
  }
?>

</page>

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