title: view data from database table
body: <pre><code>SELECT dun, COUNT( id_ahli ) AS JUMLAH_KESELURUHAN, COUNT(kaum='melayu') AS melayu, COUNT(kaum='cina') AS cina 
  FROM maklumat_ahli
  WHERE jantina = 'lelaki'
  AND 
  (kematian_tarikh IS NULL)
  AND (bayaran_pertama IS NULL)
  AND (bayaran_kedua IS NULL)
  GROUP BY dun
  ORDER BY dun
  </code></pre>
  
  <p>this is my sql statement. Is it posible to count and view data by kaum?. i use that sql statement, but my count is not correct</p>
  
  <pre><code>/-----------------------------------------/
  |dun | Jumlah_keseluruhan | melayu | cina |
  -------------------------------------------
  |A   |123                 |100     |23    |
  -------------------------------------------
  </code></pre>
  
  <p>is it any possible way to view data from db like the table above. </p>