如何动态输出PHP数组？

[pengboy]

数据库内容如下
mid colname data

56 name 张三
56 age 20

我想要的结果是，根据MID，求出内容，而内容形成数组
如
rs["name"]=张三
rs["age"]=20

[xuzuning]

...

$result = mysql_query('....');
while($r = mysql_fetch_assoc($result)) {
$rs['name'] = $r['age'];
}

[CunningBoy]

<?php
$result = mysql_query("SELECT colname, data FROM table_name WHERE id = '56'");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf("ID: %s  Name: %s", $row[0], $row[1]);  
}
?> 

[jusin2y]

拿点分...

[kyzy_yy_pm]

$result = mysql_query('select data from tablename');
$rs = array();
while($row = mysql_fetch_assoc($result)) {
  $rs['name'][] = $row['name'];
  $rs['data'][] = $row['data'];
}
print_r($rs);

[pengboy]

[Quote=引用 2 楼 cunningboy 的回复:]

PHP code
<?php
$result = mysql_query("SELECT colname, data FROM table_name WHERE id = '56'");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf("ID: %s Name: %s", $row[0], $row[1]);……
[/Quote]
什么思路？

[落叶秋2020]

$exec="select * from 表名";
$result=mysql_query($exec);
$rs=mysql_fetch_array($result);
$age=$rs["age"];
$name=$rs["name"];

[落叶秋2020]

//循环
$exec="select * from 表名";
$result=mysql_query($exec);
while($rs=mysql_fetch_array($result){
$age=$rs["age"];
$name=$rs["name"];
}

[Dleno]

<?php
$rs=array();
$result = mysql_query("SELECT colname, data FROM table_name WHERE mid = '56'");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    $rs[$row["colname"]]=$row["data"];
}
?> 

[Dleno]

咋觉得都没看清楚题意呢？

[natici]

$result = mysql_query('select id from cx_member where role_id = 4');
	for($i=0;$i<mysql_num_rows($result);$i++){
		$tmp[] = mysql_fetch_array($result);
	}
	foreach($tmp as $key=>$val){
		$rs['"'.$val['colname'].'"'] = $val['data'];
	}
print_r($rs);

[rscpassrsc]

都是强人啊

[funfun5433]

每天回帖即可获得10分可用分！小技巧：