arrays help needed

[doforumda]

Hi. I want to use json with php. I am getting data from database. now I want to format that in this way

 

{ msg: [{"id":"1"},{"id":"2"},{"id":"3"},{"id":"4"},{"id":"5"}]}

 

to work with it on client side using json.

 

here is my php code

include("db.php");
$query = mysql_query("SELECT * FROM data_table");
$id = "";
while($row = mysql_fetch_assoc($query)){
    $id = $row['id'];
    $JSON_array['msg'] = array();
    $JSON_array['msg']['id'] = $id;
    $JSON_response = json_encode($JSON_array);
    header("Contents: type/json");
    echo $JSON_response;
}

 

help please

[trq]

include("db.php");
$query = mysql_query("SELECT * FROM data_table");
$id = "";
$result = array();
while($row = mysql_fetch_assoc($query)){
    $result[]['id'] = $row['id'];
}
$JSON_response = json_encode($result);
header("Contents: type/json");
echo $JSON_response;