"; $sql1 = getFilter ($filter, $value1, $value2, $value3, $dateS, $dateE); $hookup = mysql_connect($server, $db_user, $db_passwd) or die ("DB-connect leider fehlgeschlagen"); $res = mysql_db_query($db, $sql1, $hookup); if ($res) { $numberOfArticles=mysql_num_rows($res); $offset++; $offsetPlus = $offset+5; $offsetPlus4 = $offset+4; $offsetMinus = $offset-6; if ($offset > 4) { echo " "; } if ($offset < $numberOfArticles-4) { echo $offset."-".$offsetPlus4." of [".$numberOfArticles."] articles"; echo " "; } else { echo $offset."-".$numberOfArticles." of [".$numberOfArticles."] articles "; } echo "
"; } plusDisplay ($filter, $value1, $value2, $value3); echo "
  "; echo getHeadline ($filter, $value1, $value2, $value3); echo "

"; echo "

"; if (!$offset) { $offset=0; } else { $offset--; } //Verbindung herstellen //$hookup = mysql_connect($server, $db_user, $db_passwd) or die ("DB-connect leider fehlgeschlagen"); // wir jetzt schon oben gemacht (Zeile 10) //Auslesen der relevanten DatensŠtze if ($hookup) { $sql = getFilter ($filter, $value1, $value2, $value3, $dateS, $dateE); $sql = $sql." ORDER BY date DESC LIMIT $offset,5"; //echo $sql; $result = mysql_db_query($db, $sql, $hookup); //LIMIT $offset,5 DESC if ($result) { for ($i=0; $i
  "; if ($catB == "") { echo " "; $pSwitch = "people"; $cSwitch = "peoplecity"; } else { echo " "; $pSwitch = "person"; $cSwitch = "city"; } echo " $catA $catB
$headline
"; if ($AuthorType == "guest") { echo ""; } echo $synopsis; if ($AuthorType == "guest") { echo ""; } echo " ".date('d/m/Y', $date).", by $AuthorSurname $AuthorName, $AuthorCity
/td>
 
  more   "; echo " comments [$noCOM]"; if ($type=="admin") { echo ""; echo "
"; echo " edit     delete

"; } else if ($type=="user") { echo ""; if ($authorID == $UID) { echo "
"; echo " edit     delete

"; } } else if ($type=="guest") { echo ""; if ($authorID == $UID) { echo "
"; echo " edit     delete

"; } } else{ echo ""; } echo "

 
"; } } echo ""; echo ""; /* // dieser Abschnitt ist die "latest comments" - Box // auskommtentiert da nur voller Spam if (!$filter) { echo ""; echo "
 "; echo "latest comments

"; $result = mysql_db_query($db, "SELECT * FROM $TBLcontent WHERE catA = '0' ORDER BY date DESC LIMIT 0,8", $hookup); if ($result) { for ($i=0; $i".$COMheadline." by ".$COMsurname." ".$COMname." - ".$COMheadlineArt." ".date('d/m/Y', $COMdate)."

"; } } echo "
 
"; } */ echo " "; echo "
 "; $sql1 = getFilter ($filter, $value1, $value2, $value3, $dateS, $dateE); $res = mysql_db_query($db, $sql1, $hookup); if ($res) { $numberOfArticles=mysql_num_rows($res); $offset++; $offsetPlus = $offset+5; $offsetPlus4 = $offset+4; $offsetMinus = $offset-6; if ($offset > 4) { echo " "; } if ($offset < $numberOfArticles-4) { echo $offset."-".$offsetPlus4." of [".$numberOfArticles."] articles "; echo " "; } else { echo $offset."-".$numberOfArticles." of [".$numberOfArticles."] articles "; } echo "


"; } } mysql_close ($hookup); include ('footer.php'); ?>