array_multidimensi_ipeh

<?php
mysql_connect('localhost','root','');
mysql_select_db('absen');

echo "ipeh <br>";
$sql= "SELECT F.kota, F.kode, count(id) as jml FROM
			(SELECT kota, kode FROM tabel CROSS JOIN kode) as F
		LEFT JOIN
			(SELECT * FROM data) as D
		ON (F.kota = D.kota and F.kode = D.kode)
		GROUP BY kota, kode";

$data = array();
$select = mysql_query($sql);
while ($a = mysql_fetch_array($select)){

	//echo $a['kode']." - ".$a['kota']." - ".$a['jml']."<br>";
	$data["{$a['kota']}"]["{$a['kode']}"] = $a['jml'];
	//$data[] = $a;

}

echo "<table>
		<tr>
			<th>KOTA</th>
			<th>AL</th>
			<th>AX</th>
			<th>BX</th>
		</tr>";

foreach ($data as $key => $value) {
	echo "<tr>
			<td>{$key}</td>
			<td>{$value['AL']}</td>
			<td>{$value['AX']}</td>
			<td>{$value['BX']}</td>
		  </tr>";
}
//print_r($data);