Latest News

", "", ""); if ($dbh) { $query = "SELECT id,subject,releasedate,teaser,body FROM news " . "WHERE deleted = 0 AND releasedate < now() AND teaser <> '' " . "ORDER BY releasedate DESC,insertd DESC LIMIT 7"; $sth = pg_exec ($dbh, $query); if ($sth) { for ($nr=0; $nr < pg_NumRows ($sth); $nr++) { $row = pg_fetch_array ($sth, $nr); $date = explode (" ", $row['releasedate']); if ("" == "index.html.de") { $date = explode ("-", $date[0]); $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]); } else $date = $date[0]; if (!strcmp(substr($row['body'],0,7), 'http://')) $url = $row['body']; else $url = sprintf ("/News/shownews.php?id=%d", $row['id']); echo ("

"); if (strlen ($row['body']) > 0) //printf ("%s", printf ("%s", $url, $row['subject']); else printf ("%s", $row['subject']); printf ("
%s

", $date); } } } ?>

"index.html.de" ""> "index.html.en" "">