showing announcements

[doongoan]

Hello,

 

i need to show announcements at my homepage

just like the way they appear at announcements.php

 

i used this code:

 

<?php
include("client/dbconnect.php");
include("client/includes/functions.php");
$query = "SELECT * FROM tblannouncements WHERE published='on' ORDER BY date DESC LIMIT 0,3"; 
$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("<p><font color=#cccccc>$date</font> - <br><b>$title</b><br></p>");
}
?>

 

but this code shows the title of each announcement without a link for the announcement

 

any idea how to have a link for every announcement on the title ?

 

 

Regards