session_start(); require 'includes/dbconnect.php'; include 'includes/functions.php'; //aktive Seite im Menü festlegen $menuLevel1="News"; $newsPerPage = 5; // aktuelle Seite bestimmen $actPage=0; if ($_REQUEST['actPage']) $actPage=$_REQUEST['actPage']; //News auslesen $news = mysql_query(" SELECT new_id AS new_id, new_datum AS new_datum, new_time AS new_time, new_visible AS new_visible FROM t_news WHERE new_visible=1 ORDER BY new_datum DESC, new_time DESC"); $totalNews = mysql_num_rows($news); $totalPages = ceil($totalNews/$newsPerPage); $start = $actPage * $newsPerPage; $result = mysql_query(" SELECT new_id AS new_id, DATE_FORMAT(new_datum,'%e.%m.%Y') AS new_datumF, DATE_FORMAT(new_time,'%k:%i') AS new_timeF, new_headline AS new_headline, new_short AS new_short, new_beschreibung AS new_beschreibung, new_bild AS new_bild, new_orguser AS new_orguser, new_edituser AS new_edituser, new_visible AS new_visible FROM t_news WHERE new_visible=1 ORDER BY new_datum DESC, new_time DESC LIMIT $start,$newsPerPage"); ?>