function degis($text) {
$search = array(" ","A","B","C","Ç","D","E","F","G","Ğ","H","I","İ", "J","K","L","M","N","O","Ö","P","R","S","Ş","T","U ","Ü","V","Y","Z","Q","W","X","ö","ş","ı","ğ","ü", "ç","?","!","...","'",":");
$replace = array("-","a","b","c","c","d","e","f","g","g","h","i","i", "j","k","l","m","n","o","o","p","r","s","s","t","u ","u","v","y","z","q","w","x","o","s","i","g","u", "c","","","","","");
$new_text = str_replace($search,$replace,$text);
return $new_text;
}
$num_displayed=18;
$dbhost="localhost";
$dbuser ="database";
$dbsifre="şifre";
$database="databaseadi";
$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))
{
$oyunadi=$row[6];
$sondeger = degis($oyunadi);
echo "
<a href=http://www.site.com/oyun-$row[0]-$sondeger.html>
<img src=http://www.site.com.com/files/image/$row[2] border=0 alt=$row[6] width=70 height=60></a>";
}