[PHP-DB] Top 5 list of the visited pages [PHP-DB]

[Webmaster Venstre Odense]

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/