function show_announcements($template_name) { $current_user =& singleton("current_user"); global $TPL; $query = "SELECT *\n FROM announcement \n WHERE displayFromDate <= CURDATE() AND displayToDate >= CURDATE()\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_tpl_values(); $person = $announcement->get_foreign_object("person"); $TPL["personName"] = $person->get_name(); include_template($this->get_template_dir() . $template_name); } }