Need This

[ksg91]

code to create table

CREATE TABLE announcement (
`id` int(4) auto_increament,
`text` varchar(500) NOT NULL,
`date` date,
PRIMARY KEY(id)
);

then to add announcement, you can make form and post it to

<?php
$text=$_POST['text'];
$date=date("Y-m-d");
mysql_query("INSERT INTO announcement SET tex='".$text."' ,date='".$date."' ");
?>

and to show announcements

<?php
$ann=mysql_query("SELECT text,date FROM announcement ORDER BY date desc,id desc");
while($k=mysql_fetch_array($ann))
{
$text=$k[0];
$date=$k[1];
echo "<div style=\"border:2px solid #ff0000;\">";
echo "$date<br />$text";
echo "</div>";
}
?>

[bOrN2pwn]

It works but the problem im haveing is it shows the whole text I only wana show a short descryption if you click on it you can read more.

[ksg91]

then put like these to show all announcement with shrot descrition assuming that read_ann.php is page for showing specific full annoucment

<?php
$ann=mysql_query("SELECT id,text,date FROM announcement ORDER BY date desc,id desc");
while($k=mysql_fetch_array($ann))
{
$id=$k[0]
$text=substr($k[1],0,50)."...";
$date=$k[2];
echo "<div style=\"border:2px solid #ff0000;\">";
echo "$date<br />$text<br /><a href=\"read_ann.php?id=$id\">Read More</a>";
echo "</div>";
}
?>

and code for read.ann.php will be like this

$id=$_GET['id'];
$k=mysql_fetch_array(mysql_query("SELECT text,date FROM announcement WHERE id=$id"));
$text=$k[0];
$date=$k[1];
echo "<div style=\"border:2px solid #ff0000;\">";
echo "$date<br />$text<br />";
echo "</div>";