include ('config.php'); include ('session.php'); include ('functions.php'); include ('header.php'); echo "
"; echo getHeadline ($filter, $value1, $value2, $value3); 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 "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 "; } } echo " |