Question

php 查询mysql 如何返回一个数组

$sql = "SELECT * FROM member_friends WHERE mid = ";
如何才能让上面的查询返回一个数组？
member_friends 表中包括id ，name，data，sid，等字段
如何才能返回一个
[0] => 1
[id] => 1
[1] => 6
[fid] => 6
[2] => admin
[floginid] => admin
[3] => admin
[funame] => admin
[4] => 1
[mid] => 1
[5] => 1312976550
[addtime] => 1312976550
[6] => 0
[ftype] => 0
[7] => 1
[groupid] => 1
[8] =>
[description] =>
这样的数组呢？ 回答好了给加分

Answer 1

使用mysql_fetch_array函数即可：如：$query="SELECT * FROM member_friends WHERE mid = ";
$result=mysql_fetch_array(mysql_query($query));
print_r($result);exit;

Answer 2

天南星域正解。mysql_fetch_array()正是你想要的。