<?php
$num_displayed=10;
$dbhost="localhost";
$dbuser ="dbuser";
$dbsifre="sifre";
$database="database";
$tabloisim ="files";
$veriyolum = mysql_connect($dbhost, $dbuser,$dbsifre);
mysql_select_db($database,$veriyolum);
$result = mysql_query("SELECT * FROM $tabloisim ORDER BY RAND() LIMIT $num_displayed",$veriyolum);
while ($row = mysql_fetch_array($result))
{
echo "
<a href=http://www.site.com/file.php?f=$row[0]>
<img src=http://www.site.com/files/image/$row[2] border=0 alt=oyun width=130 height=100></a>";
echo"$row[5]";
} ?>