Her er hele koden:
<?php
include("config.php");
$id=$_GET['id'];
if(isset($id)) {
mysql_query("UPDATE downloads SET clicks = clicks + 1 WHERE id = $id");
$query=mysql_query("SELECT * FROM downloads WHERE id = $id");
$row = mysql_fetch_array($query);
$URL = $row['URL'];
echo '<script>location.href="'.$URL.'"</script>';
exit;
}
echo '<center><font face="Verdana" style="font-size: 11px;">Alle film her på siden kræver DivX 5.0.5, Kan downloades <a href="
http://download.divx.com/divx/DivXPro505GAINBundle.exe">her</a><br>Næste gang kommer der nogle hvor jeg køre :)<br></br></font></center>';
$query=mysql_query("SELECT * FROM downloads ORDER BY clicks DESC");
while($row = mysql_fetch_array($query)) {
$storrelse = $row['size'];
$k56hast = 5.2;
$k256hast = 23.7;
$dlsek = round($storrelse / $k56hast);
$minutter56 = floor($dlsek / 60);
$sekunder56 = $dlsek % 60;
$dlsek = round($storrelse / $k256hast);
$minutter256 = floor($dlsek / 60);
$sekunder256 = $dlsek % 60;
$beskrivelse = $row['beskrivelse'];
echo '<div align="center"><table width="450" cellspacing="0" cellpadding="0" style="border-left:1px solid #000000; border-right:1px solid #000000; border-top:1px solid #000000; border-collapse: collapse"><tr>';
echo '<td width="60%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td width="100%" style="border-bottom: 1px solid #000000"><a href="index.php?id='.$row['id'].'"><b><font face="Verdana" style="font-size: 11px;">'.$row['overskrift'].'</font></b></a></td></tr><tr><td width="100%"><font face="Verdana" style="font-size: 11px;">'.nl2br($beskrivelse).'</font></td></tr></table></td>';
echo '<td width="40%" height="140" style="border-left:1px solid #000000;"><center><a href="index.php?id='.$row['id'].'"><img src="'.$row['thumbnail'].'" width="160" height="120"></a></center></td></tr></table></div>';
echo '<div align="center"><table width="450" cellspacing="0" cellpadding="0" style="border:1px solid #000000"><tr>';
echo '<tr><td width="20%" style="border-right: 1px solid #000000" style="border-bottom: 1px solid #000000"><b><font face="Verdana" style="font-size: 11px;">Downloadet:</font></b></td><td width="80%" style="border-bottom: 1px solid #000000"><font face="Verdana" style="font-size: 11px;">'.$row['clicks'].' gang(e)</font></td></tr>';
echo '<tr><td width="20%" style="border-right: 1px solid #000000"><b><font face="Verdana" style="font-size: 11px;">Størrelse:</font</b></td><td width="80%"><font face="Verdana" style="font-size: 11px;">'.$row['size'].' kb ('.$minutter56.':'.$sekunder56.'min @ 56K | '.$minutter256.':'.$sekunder256.'min @ 256K)</font></td></tr></tr></table></div><br><br>';
}
?>