0) {
$dbh = pg_pconnect ("kuolema", "5432", "web")
or die("Unable to connect to SQL server");
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
$query = "SELECT releasedate,ticker FROM ticker WHERE oid = '$ups'";
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
$date = date ("j.m.Y");
$ticker = "von Infodrom Oldenburg";
if (pg_NumRows ($sth) > 0) {
$row = pg_fetch_array ($sth, 0);
$date = explode (" ", $row['releasedate']);
$time = explode (":", $date[1]);
$date = explode ("-", $date[0]);
$date = sprintf ("%d.%d.%d %d:%d", $date[2], $date[1], $date[0], $time[0], $time[1]);
$tick['ticker-chip'] = "von CHIP Online";
$tick['ticker-firstlinux'] = "von FirstLinux";
$tick['ticker-gnn'] = "von Golem News";
$tick['ticker-internetnews'] = "von Internet News";
$tick['heise-ticker'] = "vom Heise Newsticker";
$tick['ticker-linuxcommunity'] = "von Linux-Community";
$tick['ticker-linuxde'] = "von Linux.de";
$tick['ticker-linuxmag'] = "vom Linux-Magazin";
$tick['ticker-linuxpr'] = "von LinuxPR";
$tick['ticker-linuxtoday'] = "von Linux Today";
$tick['ticker-lwn'] = "von Linux Weekly News";
$tick['ticker-prolinux'] = "von Pro Linux";
$tick['ticker-slashdot'] = "von Slashdot";
$tick['ticker-zdnet'] = "von ZDNet";
$ticker = $tick[$row['ticker']];
}
}
?>