THE BUNGHOLE - Top Ten Sites";
?>
= 20 ORDER BY rating DESC, votes DESC LIMIT 10;");
$totalnumber = mysql_num_rows($query);
echo "
\n";
echo "Rating | | Votes | | Resource |
";
while(($item = mysql_fetch_array($query))) {
echo "",$item["rating"]/100," | | ";
echo "",$item["votes"]," | | ";
echo "",$item["title"]," |
";
}
echo "
\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
make_title("Top 10 resources (by votes)");
$query = mysql_query("SELECT title, id, rating, votes FROM bunghole_links WHERE votes >= 20 ORDER BY votes DESC, rating DESC LIMIT 10;");
$totalnumber = mysql_num_rows($query);
echo "\n";
echo "Rating | | Votes | | Resource |
";
while(($item = mysql_fetch_array($query))) {
echo "",$item["rating"]/100," | | ";
echo "",$item["votes"]," | | ";
echo "",$item["title"]," |
";
}
echo "
\n";
echo "\n";
echo "\n";
echo "
\n";
echo "
\n";
echo "\n";
echo "\n";
echo "\n";
make_title("Top 10 resources (by hits)");
$query = mysql_query("SELECT title, id, hits, rating, votes FROM bunghole_links ORDER BY hits DESC, votes DESC LIMIT 10;");
$totalnumber = mysql_num_rows($query);
echo "\n";
echo "Rating | | Votes | | Hits | | Resource |
";
while(($item = mysql_fetch_array($query))) {
echo "",$item["rating"]/100," | | ";
echo "",$item["votes"]," | | ";
echo "",$item["hits"]," | | ";
echo "",$item["title"]," |
";
}
echo "
\n";
mysql_close($db);
?>