Læs mere - funktion ved hver artikel.

HER ER MIN KODE:

<?php
$today = getdate();
$month = $today['month'];
$mday = $today['mday'];
$year = $today['year'];
?>
<?
$foresp = mysql_query("SELECT * FROM news_class ORDER BY id DESC");
while($data = mysql_fetch_array($foresp))
{
$data[5] = substr($data[5],0,150) ;
// Billede
    echo "<tr>";
    echo "<td valign=\"top\" width=\"30\" style=\"height: 0px; background-image: url(frames/v.gif)\"></td>";
    echo "<td valign=\"top\" width=\"300\" style=\"height: 0px; background-image: url(frames/c.gif)\"><div align=\"center\"><img src=$data[4] width=\"200\" border=\"1\">";
    echo "</td>";
    echo "<td valign=\"top\" width=\"30\" style=\"height: 0px; background-image: url(frames/e.gif)\"></td>";
    echo "</tr>";



// Titel
    echo "<tr>";
    echo "<td valign=\"top\" width=\"30\" style=\"height: 20px; background-image: url(frames/v.gif)\"></td>";
    echo "<td valign=\"top\" width=\"300\" style=\"height: 20px; background-image: url(frames/c.gif)\"><h3><b>$data[2]</b></h3>";
    echo "</td>";
    echo "<td valign=\"top\" width=\"30\" style=\"height: 20px; background-image: url(frames/e.gif)\"></td>";
    echo "</tr>";

// Broedtekst
    echo "<tr>";
    echo "<td valign=\"top\" width=\"30\" style=\"height: 20px; background-image: url(frames/v.gif)\"></td>";
    echo "<td valign=\"top\" width=\"300\" style=\"height: 20px; background-image: url(frames/c.gif)\"><b>$data[3]</b>";
    echo "</td>";
    echo "<td valign=\"top\" width=\"30\" style=\"height: 20px; background-image: url(frames/e.gif)\"></td>";
    echo "</tr>";

// Beskrivelse
    echo "<tr>";
    echo "<td valign=\"top\" width=\"30\" style=\"height: 30px; background-image: url(frames/v.gif)\"></td>";
    echo "<td valign=\"top\" width=\"300\" style=\"height: 30px; background-image: url(frames/c.gif)\">$data[5]";
    echo "</td>";
    echo "<td valign=\"top\" width=\"30\" style=\"height: 30px; background-image: url(frames/e.gif)\"></td>";
    echo "</tr>";

// forfatter
    echo "<tr>";
    echo "<td valign=\"top\" width=\"30\" style=\"height: 50px; background-image: url(frames/v.gif)\"></td>";
    echo "<td valign=\"top\" width=\"300\" style=\"height: 50px; background-image: url(frames/c.gif)\"><p><i>Skrevet af $data[1] </i>";
    echo "<i><font class=ur>  $dag den $dato. $mnd</font></i>";
    echo "<i> $year</i>";
    echo "<a href=\"?slet=$data[id]\"><blockquote>Slet</a>";
    echo "<hr>";
    echo "</td>";
    echo "<td valign=\"top\" width=\"30\" style=\"height: 50px; background-image: url(frames/e.gif)\"></td>";
    echo "</tr>";


}
?>

<?php
$query = mysql_query("SELECT * FROM tabel WHERE id=1");
$row = mysql_fetch_array($query);

echo "$row[overskrift]<br><br>";
echo "$row[tekst]";
?>

Byg selv videre :)

Linje 22 ændre du til:

echo "<td valign=\"top\" width=\"300\" style=\"height: 20px; background-image: url(frames/c.gif)\"><h3><b><a href=\"visnyhed.php?id=$row[id]\">$data[2]</a></b></h3>";

og så laver du en fil kaldet visnyhed.php som ser nogenlunde sådan her ud:

<?php
mysql_connect("","","");
mysql_select_db("");
$query = mysql_query("SELECT * FROM news_class WHERE id=$_GET[id]");
$row = mysql_fetch_array($query);

echo "$row[overskrift]<br><br>";
echo "$row[tekst]";
?>

Dette er dog kun hvis du vil ha' overskriften til at fungere som link til hele nyheden.

du kan benytte den sql streng til dette formål:

$news = mysql_query("SELECT *, CONCAT(SUBSTRING_INDEX(tabelfelt_nyhed, ' ', 20), ' ') AS short FROM tabel) or die (mysql_error());

tallet 20 kan du ændre på det er den der regulerer hvormeget der skal hives ud af databasen