Stats Display

[bentleykf]

I want to create a statistics display with MySQL and php. I've already got a script that grabs page hits from a page and puts that into a MySQL table. What I want to do now is to create a script that displays the top 10 pages from that MySQL table, how would I go about acheiving this?
-bentley k. frog

 

[spookie]

$host = "urhostname" ;
$username = "mysqlusername" ;
$password = "urpassword" ;
mysql_connect($host,$username,$password) ;

mysql_select_db("dbname&quot ;

$sql = "select * from tablename order by pagehits LIMIT 10" ;

$result = mysql_query($sql) ;

whille ($row = mysql_fetch_array) {

$field1 = $row["field1"] ;
$field2 = $row["fiels2"] ;
..

echo $field1 ;
echo $field2 ;
}

mysql_close() ;