cara menghitung berdasarkan kesamaan

Coba select distinct dulu gan, lalu tampilkan row hasil query nya. Contoh :

$query  = "SELECT DISTINCT dusun from tabel";
$jumlah = num_rows;

//Jadi jumlah dusun nya :
echo "Jumlah Dusun : ". $jumlah;

terimakasih gan.. sudah bisa.. oh iyaa.. bagiamana saya bisa menampilkan berapa jumlah jenis kelamin Laki-Laki dan berapa Perempuan??

ok gan. fix.. terima kasih

<pre> mohon bantuannya bagaimana menghitung total untuk setiap kolomnya &lt;?php include 'DBController.php'; $db_handle = new DBController(); $opdResult = $db_handle-&gt;runQuery("SELECT DISTINCT opd FROM rb_jenis_belanja ORDER BY opd ASC");

?&gt;

&lt;html&gt; &lt;head&gt;

&lt;link href="style.css" type="text/css" rel="stylesheet" /&gt;

&lt;/head&gt; &lt;tbody&gt;

<h2>REALISASI BELANJA</h2>

 <li><a href="http://walsibela.nagekeokab.go.id/index.php" </i><h2> KEMBALI KE BERANDA<h2></a></li>
 <li><a href="http://walsibela.nagekeokab.go.id/printjenisbelanja.php" </i><h2> Lanjut Print<h2></a></li>
<form method="POST" name="search" action="printopd.php">
    <div id="demo-grid">
        <div class="search-box">
            <select id="Place" name="opd[]" multiple="multiple">
                <option value="0" selected="selected">PILIH PD</option>
                    <?php
                    if (! empty($opdResult)) {
                        foreach ($opdResult as $key => $value) {
                            echo '<option value="' . $opdResult[$key]['opd'] . '">' . $opdResult[$key]['opd'] . '</option>';
                        }
                    }
                    ?>
            </select><br> <br>
            <button id="Filter">Pilih</button>
        </div>
        
            <?php
            if (! empty($_POST['opd'])) {
                ?>
                
                <table cellpadding="10" cellspacing="1">
            
            <thead>
                <button type="submit" onclick="window.print()">Print</h2></button>
                
                <tr>
                    <th><strong>Tahun Anggaran</strong></th>
                    <th><strong>PD</strong></th>
                    <th><strong>Program</strong></th>
                    <th><strong>Kegiatan</strong></th>
                    <th><strong>Sub Kegiatan</strong></th>
                    <th><strong>Jenis Belanja</strong></th>
                    <th><strong>Jenis Pengadaan</strong></th>
                    <th><strong>Metode Pengadaan</strong></th>
                    <th><strong>Paket Pekerjaan</strong></th>
                    <th><strong>Nilai Pagu</strong></th>
                    <th><strong>Volume Pekerjaan</strong></th>
                    <th><strong>Detail Lokasi</strong></th>
                    <th><strong>Sumber Dana</strong></th>
                    <th><strong>Pelaksana</strong></th>
                    <th><strong>Nilai Kontrak</strong></th>
                    <th><strong>Tanggal Kontrak</strong></th>
                    <th><strong>Nomor Kontrak</strong></th>
                    <th><strong>Tanggal Mulai</strong></th>
                    <th><strong>Tanggal Selesai</strong></th>
                    <th><strong>Jangka Waktu Pelaksanaan</strong></th>
                    <th><strong>Sisa Pagu</strong></th>
                    <th><strong>Jenis Pengajuan Anggaran</strong></th>
                    <th><strong>Prosentase Pengajuan Dana</strong></th>
                    <th><strong>Keterangan Akhir</strong></th>


                </tr>
            </thead>
            <tbody>
            <?php
                
                $query = "SELECT * from rb_jenis_belanja";
                $i = 0;
                $selectedOptionCount = count($_POST['opd']);
                $selectedOption = "";
                while ($i < $selectedOptionCount) {
                    $selectedOption = $selectedOption . "'" . $_POST['opd'][$i] . "'";
                    if ($i < $selectedOptionCount - 1) {
                        $selectedOption = $selectedOption . ", ";
                    }
                    
                    $i ++;
                }
                
                $query = $query . " WHERE opd in (" . $selectedOption . ")";
                
                
                $result = $db_handle->runQuery($query);
                
            }
            if (! empty($result)) {
                foreach ($result as $key => $value)
                
                
                {
                    ?>
                    
                    
            <tr>
                    <td><div class="col" id="user_data_1"><?php echo $result[$key]['tahun_anggaran']; ?></div></td>
                    <td><div class="col" id="user_data_1"><?php echo $result[$key]['opd']; ?></div></td>
                    <td><div class="col" id="user_data_2"><?php echo $result[$key]['program']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['kegiatan']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['sub_kegiatan']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['jenis_belanja']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['jenis_barang_jasa']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['cara_pengadaan']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['nama_paket_pekerjaan']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['nilai_pagu']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['volume_pekerjaan']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['detail_lokasi']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['sumber_dana']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['pelaksana']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['nilai_kontrak']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['tanggal_kontrak']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['nomor_kontrak']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['tanggal_mulai']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['tanggal_selesai']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['jumlah_hari']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['sisa_pagu']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['jenis_pengajuan_anggaran']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['prosentase_pengajuan_dana']; ?> </div></td>
                    <td><div class="col" id="user_data_3"><?php echo $result[$key]['keterangan_akhir']; ?> </div></td>
                    
                    
                    
                </tr>
                

&lt;?php } ?&gt;

&lt;tr&gt;

	<td colspan="9">TOTAL</td>
	<td $cnt = mysql_num_rows(mysql_query("SELECT COUNT(opd) FROM rb_jenis_belanja"));

echo $cnt;&lt;/td&gt;

 </tr>   

                
            </tbody>
        </table>
        <?php
            }
            ?>  
    </div>
</form>

&lt;/body&gt;

&lt;/html&gt;

&lt;/html&gt; <br></pre>