Buscar por Downloads
Categorias
$sql = mysql_query("SELECT * FROM {$prefixo}categorias ORDER BY nome ASC") or die(mysql_error());
while($cat = mysql_fetch_array($sql)) {
$sql2 = mysql_query("SELECT * FROM {$prefixo}downloads WHERE categoria = '".$cat[nome]."'") or die(mysql_error());
$contar = mysql_num_rows($sql2);
echo "» ".$cat[nome]." (".$contar.") \n";
}
?> |
|
Top 5 Downloads:
$sql = mysql_query("SELECT * FROM {$prefixo}downloads ORDER BY cliques DESC LIMIT 5") or die(mysql_error());
$linha = mysql_num_rows($sql);
echo " ";
$i = 1;
while($n = mysql_fetch_array($sql)) {
if($i >0 && $i < 10)
$z = 0;
else
$z = "";
echo "";
echo "| ".$z."".$i++.". | ";
echo "".$n[nome]." | ";
echo "".$n[cliques]." cliques | ";
echo "Categoria: ".$n[categoria]." | ";
echo " ";
}
echo " ";
echo "
Últimos 5 downloads adicionados: ";
$novos = mysql_query("SELECT * FROM {$prefixo}downloads ORDER BY id DESC LIMIT 5") or die(mysql_error());
echo "";
$j = 1;
while($b = mysql_fetch_array($novos)) {
if($j >0 && $j < 10)
$ze = 0;
else
$ze = "";
echo "";
echo "".$ze."".$j++.". | ";
echo "".$b[nome]." | ";
echo "".$b[cliques]." cliques | ";
echo "Categoria: ".$b[categoria]." | ";
echo " ";
}
echo " ";
?>
|
|