HOLA ESTE SCRIPT TOMA TODAS LAS DESCARGAS EN LA BD Y LAS ORDENA SEGUN COUNT EN FORMA DECRECIENTE, EL PROBLEMA ES QUE QUIERO HACER QUE SOLO ME MUESTRE SOLO LOS 10 MAS DESCARGADOS.
COMO HAGO PARA LIMITAR EL RESULTADO DE LA CONSULTA A LA BD LUEGO DE ORDENARLA?
Código PHP:
$numofpages = $totalrows / $limit;
$limitvalue = $page * $limit - ($limit);
if(isset($_POST['sort_sub']))
{
$sort = htmlentities($_POST['sort'], ENT_QUOTES);
$order = htmlentities($_POST['order'], ENT_QUOTES);
} else {
$sort = "count";
$order = "DESC";
}
$query = "SELECT dID, dName, dDesc, thumb, author, dateAdd, count, version FROM ".DB_PREFIX."downloads WHERE sticky = '0' && approved = '1' ORDER BY ".$sort." ".$order." LIMIT $limitvalue, $limit";
$result = mysql_query($query);
if($noSticky == '0' && $totalrows == '0')
{
$down_page = "{*NO_DOWNS*}";
} else {
while($r=mysql_fetch_array($result))
{
$dID=stripslashes($r["dID"]);
$dName=stripslashes($r["dName"]);
$version=$r["version"];
$dDesc=substr(stripslashes($r["dDesc"]), 0, 300);
$author=stripslashes($r["author"]);
$dateAdd=stripslashes($r["dateAdd"]);
$count=stripslashes($r["count"]);
$rating=rating($dID, 1);
$thumb=stripslashes($r["thumb"]);
$thumb_nail = "<img src='".$thumb."' width='100px' alt='www.software-p2p.com' border='0'>";
$down_row = str_replace("{php=down_id}", $dID, $tableRow);
$down_row = str_replace("{php=down_name}", $dName, $down_row);
$down_row = str_replace("{php=version}", $version, $down_row);
$down_row = str_replace("{php=sticky}", "", $down_row);
$down_row = str_replace("{php=down_desc}", $dDesc, $down_row);
$down_row = str_replace("{php=author}", $author, $down_row);
$down_row = str_replace("{php=date_added}", $dateAdd, $down_row);
$down_row = str_replace("{php=down_count}", $count, $down_row);
$down_row = str_replace("{php=rating}", $rating, $down_row);
$down_row = str_replace("{php=thumbnail}", $thumb_nail, $down_row);
$allfiles_page .= $down_row;
}