I need a script that produces a top 5 list of the visited pages at my website..
$result = mysql_query(" SELECT artikel, count(*) from artikel_vist group by artikel ORDER BY artikel DESC LIMIT 5 ", $link); $num_rows = mysql_num_rows($result); while ($raekke = mysql_fetch_array($result)) { extract($raekke); $nr = $nr+1; echo "<BR><B>$nr.</B> Artikel: $artikel antal: $num_rows "; } Tabelname: artikel_vist Column: 1) nr 2) artikel 3) ip 4) time Kind regards Christian http://www.venstre-odense.dk/