$result = mysql_query("SELECT * FROM distritos order by nome asc") or die (mysql_error());
while($dist = mysql_fetch_array($result)){
$busca = mb_convert_encoding($dist['nome'], 'UTF-8', 'ISO-8859-1');
$busca1 = $dist['id'];
$query = "SELECT * FROM anuncios where distrito='$busca1' and op='ativo'";
$query = mysql_query($query);
$total = mysql_num_rows($query);
echo "".$busca. " (" .$total. ") ";
}?>
|
|