mysql_connect("localhost","superclix","sqlhigh873");
mysql_select_db("musichitsde");
$Zeilen_pro_Seite = 100;
if (!isset($site)) {
$site = 0;
}
$sql="select Term,ID,HitCount from `lsql_SearchLog` where Results > 0 ORDER BY HitCount DESC limit 100";
$result=mysql_query($sql);
$result1=mysql_query("select`ID` from `lsql_SearchLog`");
$Anzahl=mysql_num_rows($result1);
while ($row=mysql_fetch_array($result)) {
$feld1=$row["Term"];
$feld2=$row["Term"];
$feld2=str_replace(' ', '+', $feld2);
$feld2=str_replace('%20', '+', $feld2);
$feld2=str_replace('&', '+', $feld2);
$feld2=str_replace('search.cgi', 'mp3', $feld2);
$feld2=str_replace('/', '', $feld2);
$feld2=str_replace('ö', 'ö', $feld2);
$feld2=str_replace('ä', 'ä', $feld2);
$feld2=str_replace('.', '+', $feld2);
$feld2=str_replace(',', '.', $feld2);
$feld2=str_replace('!', '+', $feld2);
$feld2=str_replace('+', '+', $feld2);
$feld2=str_replace('%E4', 'ä', $feld2);
$feld2=str_replace('back+gif', 'musik', $feld2);
$feld1=str_replace('back.gif', 'musik', $feld1);
$feld1=str_replace('/', '', $feld1);
$feld1=str_replace('ö', 'ö', $feld1);
$feld1=str_replace('ä', 'ä', $feld1);
echo "$feld1
";
}
if($Anzahl>$Zeilen_pro_Seite) {
$Seiten=intval($Anzahl/$Zeilen_pro_Seite);
if($Anzahl%$Zeilen_pro_Seite) {
$Seiten++;
}
}
?>