echo "
<body link=\"#FFFFFF\" vlink=\"#FFFFFF\" alink=\"#FFFFFF\" text=\"#FFFFFF\" bgcolor=\"#03747A\">
<div align=\"center\">
<table border=\"5\" cellpadding=\"5\" cellspacing=\"5\" bordercolorlight=\"#FF0000\" bordercolordark=\"#FFFFFF\" bgcolor=\"#03747A\" height=\"186\">
<tr>
<td colspan=\"6\" align=\"center\" height=\"54\"><b><font color=\"#FFFFFF\" size=\"4\">HER
ILDE BULUNAN UYELIK TURLERI</font></b></td>
</tr>
<tr>
<td align=\"center\" height=\"57\"><font size=\"4\" color=\"#FFFFFF\"><b>NO</b></font></td>
<td align=\"center\" height=\"57\"><font size=\"4\" color=\"#FFFFFF\"><b>ILI</b></font></td>
<td align=\"center\" height=\"57\"><font size=\"4\" color=\"#FFFFFF\"><b>BUYUKSEHIR</b></font></td>
<td align=\"center\" height=\"57\"><font size=\"4\" color=\"#FFFFFF\"><b>IL</b></font></td>
<td align=\"center\" height=\"57\"><font size=\"4\" color=\"#FFFFFF\"><b>ILCE</b></font></td>
<td align=\"center\" height=\"57\"><font size=\"4\" color=\"#FFFFFF\"><b>BELDE</b></font></td>
</tr>
";
$no =0;
$beldesayisi =0;
$ilcesayisi =0;
$ilsayisi =0;
$buyuksehirsayisi =0;
$sql="Select aktif,iller as ili,
sum(case when (belturu='Il') then 1 else 0 end) as IlSayisi,
sum(case when (belturu='Ilce') then 1 else 0 end) as IlceSayisi,
sum(case when (belturu='Belde') then 1 else 0 end) as BeldeSayisi,
sum(case when (belturu='BuyukSehir') then 1 else 0 end) as BuyukSehirSayisi
from illerimiz
left join hazurun on hazurun.ili = illerimiz.iller
group by iller
order by iller";
$dizi = mysql_query($sql);
while ($sira = mysql_fetch_array($dizi)){
$iladi =$sira["ili"];
$ilce =$sira{"IlceSayisi"};
$il =$sira["IlSayisi"];
$belde =$sira["BeldeSayisi"];
$buyuksehir =$sira["BuyukSehirSayisi"];
$no++;
$beldesayisi =$belde+$beldesayisi;
$ilcesayisi =$ilce+$ilcesayisi;
$ilsayisi =$il+$ilsayisi;
$buyuksehirsayisi =$buyuksehir+$buyuksehirsayisi;
$aktif =$sira["aktif"];
if (($buyuksehir=="0") and ($il=="0") and ($ilce=="0") and ($belde=="0")){
echo "
<tr>
<td>$no</td>
<td><b>$iladi <br><b><font color=\"#FFFF00\" size=\"4\">Bu Ilde Hiç Üyemiz Yok</font></b></b></td>
<td align=\"center\">$buyuksehir</td>
<td align=\"center\">$il</td>
<td align=\"center\">$ilce</td>
<td align=\"center\">$belde</td>
</tr>
";
}else
echo "
<tr>
<td>$no</td>
<td><b>$iladi</b></td>
<td align=\"center\">$buyuksehir</td>
<td align=\"center\">$il</td>
<td align=\"center\">$ilce</td>
<td align=\"center\">$belde</td>
</tr>
";
}
$geneltoplam =$beldesayisi+$ilcesayisi+$ilsayisi+$buyuksehirsayisi;
echo "
<tr>
<td width=\"27\"> </td>
<td width=\"143\"><font color=\"#FFFF00\" size=\"4\"><b>TOPLAMLAR --></b></font></td>
<td align=\"center\" width=\"137\"><font color=\"#FFFF00\" size=\"4\"><b>
$buyuksehirsayisi</b></font></td>
<td align=\"center\" width=\"61\"><font color=\"#FFFF00\" size=\"4\"><b>
$ilsayisi</b></font></td>
<td align=\"center\" width=\"77\"><font color=\"#FFFF00\" size=\"4\"><b>
$ilcesayisi</b></font></td>
<td align=\"center\" width=\"92\"><font color=\"#FFFF00\" size=\"4\"><b>
$beldesayisi</b></font></td>
</tr>
<tr>
<td width=\"27\"> </td>
<td width=\"143\"><font color=\"#FFFF00\" size=\"4\"><b>GENEL TOPLAM--></b></font></td>
<td align=\"center\" width=\"137\"><font color=\"#FFFF00\" size=\"4\"><b>
$geneltoplam</b></font></td>
<td align=\"center\" width=\"61\"><font color=\"#FFFF00\" size=\"4\"><b>
</b></font></td>
<td align=\"center\" width=\"77\"><font color=\"#FFFF00\" size=\"4\"><b>
</b></font></td>
<td align=\"center\" width=\"92\"><font color=\"#FFFF00\" size=\"4\"><b>
</b></font></td>
</tr>
</table>
</div>
";