mysql创建多维表_从一个mysql表创建多维数组

我试图从一个mysql表中生成嵌套的json数据，如本例中所示。

var data = {

"62" : {

"section" : "bodyImage",

"img" : "imageurl/image62.png",

"label" : "blue",

"price" : "100"

},

"63" : {

"section" : "bodyImage",

"img" : "imageurl/image63.png",

"label" : "red",

"price" : "120"

}

}62和63来自下表中的data_id行：

+-----------+------------+-------------------------+-------+---------+

| data_id | section | img | label | price |

+-----------+------------+-------------------------+-------+----------

| 62 | bodyImage | imagpath/image62.png | blue | 100 |

| 63 | bodyImage | imagpath/image62.png | red | 120 |

+-----------+------------+-------------------------+-------+---------

+这是查询的php文件：

$result = mysql_query("SELECT data_id, section, img, label, price FROM table WHERE active != 'no'");

$data = array();

while($row=@mysql_fetch_object($result)) {

$data[] = array (

'section' => $row['sub_section'],

'img' => $row['big_image'],

'label' => $row['label_client_en'],

'price' => $row['price']

);

}

echo json_encode( $data );我无法得到它的工作。请帮助我使用多维数组的正确语法。