pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
- $query = "SELECT oid,name,country,city,changed FROM zeitungen WHERE deleted IS NULL";
+ $query = "SELECT oid,name,city,changed FROM zeitungen WHERE deleted IS NULL";
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
$num = pg_NumRows ($sth);
echo ('<ul>');
for ($nr=0; $nr < $num; $nr++) {
$row = pg_fetch_array ($sth, $nr);
- printf ('<li><a href="update.php?approve=%d">%s</a>, %s (%s) <a href="update.php?delete=%d">löschen</a></li>',
+ printf ('<li><a href="update.php?approve=%d">%s</a>, %s <a href="update.php?delete=%d">löschen</a></li>',
$row['oid'],
$row['name'],
- $row['country'],
$row['city'],
$row['oid']);
}