$tick['ticker-chip'] = "CHIP";
$tick['ticker-firstlinux'] = "FirstLinux";
$tick['ticker-gnn'] = "Golem";
$tick['ticker-internetnews'] = "Internet News";
$tick['heise-ticker'] = "Heise";
$tick['ticker-linuxcommunity'] = "Linux-Community";
$tick['ticker-linuxde'] = "Linux.de";
$tick['ticker-linuxmag'] = "Linux-Magazin";
$tick['ticker-linuxpr'] = "LinuxPR";
$tick['ticker-linuxtoday'] = "Linux Today";
$tick['ticker-lwn'] = "Linux Weekly";
$tick['ticker-prolinux'] = "Pro Linux";
$tick['ticker-slashdot'] = "Slashdot";
$tick['ticker-zdnet'] = "ZDNet";
$dbh = pg_pconnect ("", "", "")
or die("Unable to connect to SQL server");
pg_exec ($dbh, "SET DateStyle = 'ISO'"); // ignore or die("Datenbank-Abfrage!");
$query = "SELECT subject,oid,releasedate,ticker FROM linuxticker "
. "WHERE deleted = 0 AND releasedate < now() "
. "ORDER BY releasedate DESC "
. "LIMIT ";
$sth = pg_exec ($dbh, $query); // or die("Datenbank-Abfrage!");
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]);
$ticker = $tick[$row['ticker']];
printf ("%s: %s (%s) [read] ", $date, $row['subject'], $ticker, $row['oid']);
?>
# Das hier ist *NUR* ein vertikaler Abstand...
}
?>
|