Top 5 list of the visited pages [PHP-DB]
| From: | Webmaster Venstre Odense | Date: | Tue, 13 Nov 2001 20:40:55 +0000 |
| Subject: | Top 5 list of the visited pages [PHP-DB] | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14298@lists.php.net to get a copy of this message | ||
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/