<?
function newsbox ()
{
- $maxnews = 2;
$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 id,subject,author,teaser,body,releasedate FROM news "
- ."WHERE deleted = 0 AND releasedate < now() AND teaser <> '' ORDER BY releasedate DESC,insertd DESC";
+ ."WHERE deleted = 0 AND releasedate < now() AND teaser <> '' "
+ ."ORDER BY releasedate DESC,insertd DESC "
+ ."LIMIT 7";
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
- for ($nr=0; $nr < pg_NumRows ($sth) && $nr < $maxnews; $nr++) {
+ for ($nr=0; $nr < pg_NumRows ($sth) $nr++) {
$row = pg_fetch_array ($sth, $nr);
$date = explode (" ", $row['releasedate']);
$date = explode ("-", $date[0]);