prepare(' SELECT news_id, news_date, news_title, news_body, news_image, news_doc FROM sh_news WHERE news_id = :id ORDER BY news_id DESC '); $st->execute(array( ':id' => (int)$_GET['id'] )); $row = $st->fetch(); if($row) { $rs_title = $row["news_title"]; // convert any HTML entity back to character (used when message contains HTML) $rs_body = htmlspecialchars_decode($row["news_body"]); $rs_image = $row["news_image"]; $rs_doc = $row["news_doc"]; if (strlen($rs_image) > 0) { $image = '

'; } } else { $rs_title = "Unexpected database error"; $rs_body = "The news item ".(int)$_GET['id']." cannot be found"; $rs_image = ""; $rs_doc = ""; } $rs_body = blocktextfix($rs_body); } ?>
News

News Archive