日期:2014-05-17  浏览次数:20690 次

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

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;
}