function show_announcements($template_name)
{
global $TPL;
$people =& get_cached_table("person");
$query = "SELECT announcement.* \n FROM announcement \n ORDER BY displayFromDate DESC";
$db = new db_alloc();
$db->query($query);
while ($db->next_record()) {
$announcement = new announcement();
$announcement->read_db_record($db);
$announcement->set_values();
$TPL["personName"] = $people[$announcement->get_value("personID")]["name"];
$TPL["odd_even"] = $TPL["odd_even"] == "odd" ? "even" : "odd";
include_template($template_name);
}
}
