i have a problem with seelct query .. i want to display it in json array in the array.. here is my code
i have query like this :
<?php
$server_name="localhost";
$mysql_user="root";
$db_name ="db_mtma";
$mysql_pass ="";
mysql_connect($server_name, $mysql_user,"");
mysql_select_db($db_name);
// $con = mysqli_connect($server_name,$mysql_user,$mysql_pass,$db_name);
$result = array();
$query = "SELECT id_lw,gambar_lw,nama_p,COUNT(nama_p) AS jumlah_lw_by_nama_p,nama_k,COUNT(nama_k)
from lokasi_wisata JOIN
provinsi as provinsi ON provinsi.IDProvinsi = lokasi_wisata.IDProvinsi JOIN
kabupaten as kabupaten ON kabupaten.IDKabupaten = lokasi_wisata.IDKabupaten WHERE status_lw=1 GROUP BY nama_p" ;
$res = mysql_query($query);
while ($fetch = mysql_fetch_assoc($res)) {
$result[] = $fetch;
}
// print_r($result);
echo mysql_error();
echo json_encode(array('result'=>$result));
?>
the result of json like this :
{
"result": [
{
"id_lw": "22",
"gambar_lw": "1475251768.jpg",
"nama_p": "ACEH",
"jumlah_lw_by_nama_p": "1",
"nama_k": "KOTA SABANG",
"COUNT(nama_k)": "1"
},
{
"id_lw": "9",
"gambar_lw": "1475160516.jpg",
"nama_p": "BALI",
"jumlah_lw_by_nama_p": "3",
"nama_k": "BULELENG",
"COUNT(nama_k)": "3"
},
etc..
i want my result data as this :
"id_lw": "9",
"gambar_lw": "1475160516.jpg",
"nama_p": "BALI",
"jumlah_lw_by_nama_p": "3",
"nama_k": {"BULELENG" "1","TABANAN" "2"}
i want to select all nama_k and i want to know how much data in every nama_k columns
thx stackoverflow