end; switch($mode) { case 'display': $query = "SELECT * from ".NEWS_TABLE." WHERE id = '".$id."' LIMIT 1"; if (!($result = mysqli_query($connection,$query))) show_mysqli_error('news'); $row = mysqli_fetch_array($result,MYSQLI_ASSOC); $newsdate = getRealDate($row['insert_date']); $text = $row['text']; $news_title = htmlentities(stripslashes($row['title']),ENT_QUOTES); $browser_title = htmlentities(stripslashes($row['browser_title']),ENT_QUOTES); $meta_description = htmlentities(stripslashes($row['meta_description']),ENT_QUOTES); $meta_keywords = htmlentities(stripslashes($row['meta_keywords']),ENT_QUOTES); $_SESSION['DEBUG_MESSAGE'] .= "
Title: ".$news_title; $_SESSION['DEBUG_MESSAGE'] .= "
Title: ".$row['title']; // display the link if exists $info = ($row['url']) ? '[ Further Information ] ' : ''; // display the image if exists if ($row['image']) { $newsimage = $news_image_folder.$row['image']; $caption = $row['caption']; print <<

$caption

end; } print <<$news_title $text $link

$info [ Back to $pageTitle ]

end; break; default: ?>

DATE_SUB(NOW(),INTERVAL 1 YEAR)"; //$additional_where_clause = "AND archived > 0"; $additional_where_clause = ($_SESSION['include_archived']) ? "AND archived > 0" : "AND archived < 1"; $query = "SELECT * from ".NEWS_TABLE." WHERE disabled != '1' ". $additional_where_clause ." ORDER BY publication_date DESC"; if (!($result = mysqli_query($connection,$query))) show_mysqli_error('news 2'); while ($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) { $newsdate = getRealDate($row['publication_date']); $title = htmlentities(stripslashes($row['title']),ENT_QUOTES); $short_text = (get_short_text($row['text'],150)); $summary = ($short_text) ? '

'.$short_text.' ...more

' : ''; $_SESSION['DEBUG_MESSAGE'] .= "
News Date: ".$newsdate; //print the menu print<<

$newsdate

$title

$summary