{php} 
$query = "SELECT * FROM tblannouncements WHERE published='on' ORDER BY date DESC"; $result=mysql_query($query); while($data = mysql_fetch_array($result)) 
{ 
$id = $data["id"]; $date = $data["date"]; $title = $data["title"]; $announcement = $data["announcement"]; $date = fromMySQLDate($date); 
echo('
			<a href="announcements.php?id=$id"><strong>$title</strong></a>
');
}
{/php}