請問一這種陣列要怎么充值

請問一這種陣列要如何充值?
請教大家，有一個陣列，想從資料表取出值來填入，要怎麼改呢?

PHP code

$sql = "select sid,township from tbl_township where pid=1";$res = db_query($sql);            while (list($sid,$township)=mysql_fetch_row($res)):       endwhile; 

陣列型式如下：

PHP code

$provinces = array(array('sid' => 'bj', 'township' => 'Beijing'),array('sid' => 'hb', 'township' => 'Hubei'));

[解决办法]
while($row = mysql_fetch_assoc($res)) {
$provinces[] = $row;
}