File: /home/awaldron/www/archive/demo/notice_pf.php
<?php
session_start();
include("_functions.php");
echo dbconnect();
echo "<html><head><title>Print Friendly Notice</title></head>\n";
echo "<body style=\"font-size:12px;font-family:Verdana;\">\n";
$sql = "SELECT tbl_notices.*, tbl_notice_types.*, tbl_icons.icon_file, tbl_employees.fname, tbl_employees.lname FROM tbl_notices, tbl_notice_types, tbl_icons, tbl_employees WHERE tbl_notices.notice_id=".$_GET["nid"]." AND tbl_notices.notice_type_id=tbl_notice_types.notice_type_id AND tbl_notices.icon_id=tbl_icons.icon_id AND tbl_employees.username=tbl_notices.username";
$result = mysql_query($sql);
$n = mysql_fetch_array($result);
$page_title = $n["notice_type_name"];
echo "<P><span style=\"font-size:24px;\"><b>".strip_tags($n["notice_headline"])."</b></span>\n";
if ($n["notice_subhead"] != "0") echo "<P><span style=\"font-size:18px;\">".$n["notice_subhead"]."</span>\n";
echo "<P>Posted by <b>".$n["fname"]." ".$n["lname"]."</b> on ".date("l, F n, Y h:i a",$n["notice_date"])."\n<hr>\n";
if ($n["notice_body"] != "0") echo "<P>".format_body($n["notice_body"])."\n";
echo "</body></html>\n";
?>