請教大家，有一個陣列，想從資料表取出值來填入，要怎麼改呢?
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;
}