Source code for making rankings in php+mysql_PHP tutorial

//Complete source code for ranking list
//You can decide the top XX by yourself! The number entered is the number of top




if ($top){ if ($top){
$query="select count(*) as total from data";
$result=mysql_query($query);
$message_count=mysql_result($result,0,"total");
if ($key>$message_count) {$key=$message_count;}

?>

Top News Access Ranking Top

Ranking News Title
Category Popularity

$query="select id,detail,title,hits,type from data order by hits desc limit 0,$key";
$result =@mysql_query($query);
$rows=@mysql_num_rows($result);
$i=1;

while($myrow=@mysql_fetch_array($result)){
?>
$myrow[title]
$myrow[type]
$myrow[hits]" ?>

$i++;
if ($i}
?>

News Popularity Ranking Top
>