
<?php
mysql_connect ('localhost','gebruikersnaam','paswoord' ); 
mysql_select_db ('database' ); 

$query = "SELECT id,titel FROM forum ORDER BY datum DESC LIMIT 5"; 
$uitvoer = mysql_query($query) or die (mysql_error());  
 
echo("<table width=100% cellpadding=0 cellspacing=0 border=0>");
while($list = mysql_fetch_object($uitvoer)) 
{
echo("<tr><td>»&nbsp;<a href=?pagina=forum/topic&id=".$list->id."\" title='$list->titel'>");
if (strlen($list->titel) > 20) 
{ 
$afgekortwoord1 = substr($list->titel,0,17)."..."; 
echo("$afgekortwoord1");
}
else
{
echo("$list->titel");
}
echo("</a><br></td></tr>");
}
echo("</table>");

?>
 