query("SELECT kd_jenis_kb, uraian, count(*), sum(bea_pkb_pok), sum(bea_pkb_tgk1+bea_pkb_tgk2+bea_pkb_tgk3+bea_pkb_tgk4) FROM t_mstkb P, t_jeniskb W WHERE kd_wilayah='1' AND P.kd_jenis_kb=W.kode AND tg_akhir_pkb BETWEEN '$awal' AND '$ahir' GROUP BY 1,2 ORDER BY 1"); while ($d = $data->fetch(PDO::FETCH_BOTH)) { $jml=intval($d[3])+intval($d[4]); $us=$us+intval($d[2]); $js=$js+intval($d[3]); $jp=$jp+intval($d[4]); $tot=$tot+$jml; ?>

WILAYAH	UNIT	PKB POKOK	PKB TUNGGAKAN	JUMLAH