hocam reklam falan yapmayın ayıp oluyor ya Türkiyenin Site Rehberi benim bu arada size bir katkım olsun bunu alt.php ye yapıstırın ıstemıstın ya
<?
/*
T&uuml;m
SELECT kelime,count(id) AS say FROM arama GROUP BY kelime ORDER BY say DESC
Bu Ay
SELECT kelime,ay,yil,count(id) AS say FROM arama WHERE ay='06' AND yil='05' GROUP BY kelime ORDER BY say DESC
*/
$fq = "SELECT kelime,count(id) AS say FROM arama WHERE ";
$fq .= "kelime NOT LIKE '****%'";
$fq .= " AND kelime NOT LIKE '***%'";
$fq .= " AND kelime NOT LIKE '****%'";
$fq .= " AND kelime NOT LIKE 'travesti'";
$fq .= " AND kelime NOT LIKE 'am'";
$fq .= " GROUP BY kelime ORDER BY say DESC LIMIT 0,100";
$isimy = mysql_query($fq);
$iK = 1;
while($linkler = mysql_fetch_array($isimy))
{
echo("<onclick=\"window.location.href='arama.php?k elime=".make_url_friendly($linkler[kelime])."'\">");
echo("<a href=\"arama.php?kelime=".make_url_friendly($linkl er[kelime])."\">".make_url_friendly($linkler[kelime])." (".make_url_friendly($linkler[say]).")");
$iK++;
}
?>