Hello cyberturk,
Here is a modified version of the script which will only show the title
and the date. Once clicked it will show the announcement underneath the
annoucenments.
<?php
include("clients/configuration.php");
include("clients/includes/functions.php");
$link = mysql_connect($db_host,$db_username,$db_password);
mysql_select_db($db_name);
$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=\"$_SERVER[PHP_SELF]?show=1&id=$id\"><font color=#cccccc>$date</font> - $title</a></p>");
}
// You can make the announcement show on a different page
// by putting the below in a different file and changing
// where is says $_SERVER[PHP_SELF] to the url of the
// file you have made.
if($show) {
$id = $_GET['id'];
$query = "SELECT * FROM tblannouncements WHERE id='$id' 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("
$announcement</p>");
}
}
?>
Hope this helps.
Regards,
Ray