1、以id为键
$rs = mysql_query("select * from table");
while(list($id,$name) = mysql_fetch_row($rs)) {
$a[$id] = $name;
}2、以顺序为键,不保留id
$rs = mysql_query("select * from table");
while(list($id,$name) = mysql_fetch_row($rs)) {
$a[] = $name;
}3、以顺序为键,保留id
$rs = mysql_query("select * from table");
while($a[] = mysql_fetch_array($rs,MYSQL_ASSOC));
$rs = mysql_query("select * from table");
while(list($id,$name) = mysql_fetch_row($rs)) {
$a[$id] = $name;
}2、以顺序为键,不保留id
$rs = mysql_query("select * from table");
while(list($id,$name) = mysql_fetch_row($rs)) {
$a[] = $name;
}3、以顺序为键,保留id
$rs = mysql_query("select * from table");
while($a[] = mysql_fetch_array($rs,MYSQL_ASSOC));
MYSQL_ASSOC 以字段名为键
MYSQL_NUM 以下标为键
MYSQL_BOTH 两者都有