m persebaran

<?php
require_once 'koneksi.php';

if(session_id() == '')
	session_start();

$r = mysql_query("select * from tb_provinsi");

while ($row = mysql_fetch_array($r))
{
    $rr = mysql_query("select nama from tb_anggota where provinsi = '$row[provinsi]'");
    $dataset[] = array(
        "ccode" => "$row[code]",
        "nama" => "$row[provinsi]",
        "total" => (String) mysql_num_rows($rr)
    );
}

$datasets = array("provinsi" => $dataset);

echo json_encode($datasets);
?>