Top 10 in Gallery Views
$query = "SELECT * FROM filipinacelebs ORDER BY hits DESC LIMIT 10";
$result = mysql_query($query) or die("Query failed");
while($row = mysql_fetch_array($result))
{
extract($row);
$link = strtolower($title);
$link = str_replace(" ", "_", $link);
echo "".$title." (".$hits." ) ";
}
?>
|
Top 10 in Rating
$query = "SELECT * FROM filipinacelebs ORDER BY rating DESC LIMIT 10";
$result = mysql_query($query) or die("Query failed");
while($row = mysql_fetch_array($result))
{
extract($row);
$link = strtolower($title);
$link = str_replace(" ", "_", $link);
echo "".$title." (".$rating." ) ";
}
?>
|