rendered paste body<?php require("global.php");
require("database_config.php");
//Header
echo "<div align='center'>";
require("header.html");
echo "</div>";
error_reporting(E_ALL);
$query = "SELECT * FROM iframe ORDER BY website_selected DESC LIMIT 10";
$result = mysql_query($query);
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
echo "<div align='center'><b>Top 10 websites</b></div>";
while($row = mysql_fetch_array($result, MYSQL_BOTH)){
$array[] = $row;
echo "<div align='center'><a href=".$array[0]['website_url'].">".$array[0]['website_title']." - ".$array[0]['website_selected']." hits</a></div>";
//echo "<div align='center'><a href=".$array[1]['website_url'].">".$array[1]['website_title']." - ".$array[1]['website_selected']." hits</a></div>";
}
mysql_free_result($result);
?>