$host="localhost"; $user="root"; $pass="igpjaya"; $dbname="art"; $db=@mysql_connect($host, $user, $pass); if (!$db) die('Error Koneksi'); $a=mysql_select_db ($dbname,$db); if (!$a) die('Error Database'); $sql="select kddesa,kategori,count(*) jml from ppls group by kddesa,kategori"; $hasil=mysql_query($sql,$db); while ($row = mysql_fetch_array ($hasil)){ $data[$row[kddesa]][$row[kategori]]=$row[jml]; $akat[$row[kategori]]=1; $dtotal[$row[kategori]]+=$row[jml]; } $kdesa=array_keys($data); $kat=array_keys($akat); echo '
| KDDesa | '; for ($i=0;$iJUMLAH | '; echo ''.$kdesa[$i].' | '; $ttl=0; for ($j=0;$j'.number_format($ttl).' | '; echo ' '; } echo '
| TOTAL | '; $ttl=0; for ($i=0;$i'.number_format($ttl).' | '; echo '