<table>
  <tr>
    <th>İlçe</th>
    <th>Resmi</th>
    <th>Özel</th>
  </tr>
<?php
$ilceler = mysql_query("select * from tablo group by ilce");
while($ilce = mysql_fetch_array($ilceler))
{
$ilce = $ilce["ilce"];
$resmi = mysql_num_rows(mysql_query("select * from tablo where ilce='$ilce' and resmiozel='Resmi'"));
$ozel= mysql_num_rows(mysql_query("select * from tablo where ilce='$ilce' and resmiozel='Özel'"));

echo '
  <tr>
    <td>'.$ilce.'</td>
    <td>'.$resmi.'</td>
    <td>'.$ozel.'</td>
  </tr>

';
}
?>
</table>