THE BUNGHOLE - Top Ten Sites"; ?> = 20 ORDER BY rating DESC, votes DESC LIMIT 10;"); $totalnumber = mysql_num_rows($query); echo "\n"; echo ""; while(($item = mysql_fetch_array($query))) { echo ""; echo ""; echo ""; } echo "
Rating Votes Resource
",$item["rating"]/100," ",$item["votes"]," ",$item["title"],"
\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 ""; while(($item = mysql_fetch_array($query))) { echo ""; echo ""; echo ""; } echo "
Rating Votes Resource
",$item["rating"]/100," ",$item["votes"]," ",$item["title"],"
\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 ""; while(($item = mysql_fetch_array($query))) { echo ""; echo ""; echo ""; echo ""; } echo "
Rating Votes Hits Resource
",$item["rating"]/100," ",$item["votes"]," ",$item["hits"]," ",$item["title"],"
\n"; mysql_close($db); ?>