"; echo getHeadlineDiary ($filter, $value1, $value2, $value3, $dateS, $dateE); echo "
"; if (!$offset) { $offset=0; } else { $offset--; } //Verbindung herstellen $hookup = mysql_connect($server, $db_user, $db_passwd) or die ("DB-connect leider fehlgeschlagen"); //Auslesen der relevanten DatensŠtze if ($hookup) { $sql = getFilterDiary ($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",$synopis); $ID = (mysql_result($result,$i,"ID")); $authorID = (mysql_result($result,$i,"authorID")); $saveURL = "insert_diary.php"; $catANo = (mysql_result($result,$i,"catA")); $catBNo = (mysql_result($result,$i,"catB")); $pic1 = (mysql_result($result,$i,"pic1")); $pic2 = (mysql_result($result,$i,"pic2")); $pic3 = (mysql_result($result,$i,"pic3")); $url1 = (mysql_result($result,$i,"url1")); $url2 = (mysql_result($result,$i,"url2")); $url3 = (mysql_result($result,$i,"url3")); $link1 = (mysql_result($result,$i,"link1")); $link2 = (mysql_result($result,$i,"link2")); $link3 = (mysql_result($result,$i,"link3")); $COMresult = mysql_db_query($db, "SELECT * FROM $TBLcontent WHERE replyID = '$ID'", $hookup); $noCOM = mysql_num_rows($COMresult); $hookupAuthor = mysql_connect($server, $db_user, $db_passwd) or die ("DB-connect leider fehlgeschlagen"); if ($hookupAuthor) { $resultAuthor = mysql_db_query($db, "SELECT * FROM $TBLusers WHERE ID = '$authorID'", $hookupAuthor); if ($resultAuthor) { for ($j=0; $j   "; echo " "; echo date('d/m/Y', $date); echo "
"; if ($pic1 and $pic1!=-1) { echo "$headline"; } else { echo "$headline"; } echo "
$synopis by $AuthorSurname $AuthorName, $AuthorCity
"; if ($url1) { echo " "; if ($link1) { echo $link1; } else { echo $url1; } echo "
"; } if ($url2) { echo " "; if ($link2) { echo $link2; } else { echo $url2; } echo "
"; } if ($url3) { echo " "; if ($link3) { echo $link3; } else { echo $url3; } echo "
"; } echo "   "; if ($pic1 and $pic1!=-1) { echo " picture(s)   "; } if ($type=="admin") { echo "
"; echo " edit     delete

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

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

"; } } echo "

"; } } echo "
 "; $sql1 = getFilterDiary ($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-5; if ($offset > 4) { echo " "; } if ($offset < $numberOfArticles-5) { echo $offset."-".$offsetPlus4." of [".$numberOfArticles."] articles "; echo " "; } else { echo $offset."-".$numberOfArticles." of [".$numberOfArticles."] articles "; } echo "


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