AMZ_AC DE 23
AMZ_AC ES 2
AMZ_AC FR 275
AMZ_AC GB 358
AMZ_AC IT 1
CO_AC JP 233
以上数据是从数据库查询得来的,请问怎么变成以下数组(("AMZ_AC,DE,23","AMZ_AC,ES,2","AMZ_AC,FR,275","AMZ_AC,GB,358","AMZ_AC,IT,1"),("CO_AC ,JP,233))
AMZ_AC ES 2
AMZ_AC FR 275
AMZ_AC GB 358
AMZ_AC IT 1
CO_AC JP 233
以上数据是从数据库查询得来的,请问怎么变成以下数组(("AMZ_AC,DE,23","AMZ_AC,ES,2","AMZ_AC,FR,275","AMZ_AC,GB,358","AMZ_AC,IT,1"),("CO_AC ,JP,233))
解决方案 »
- php中关联多张表的问题
- 运行出现 You don't have permission to access /C:/Program Files/Apache Software Found
- 急
- php4.4.7中fopen访问http不能带端口?
- 开通了微软的邮局,怎么用php编程发他的邮件阿?
- 帮我看看代码格式是否有错
- 大家有谁能说说 悠深科技http://www.25idc.cn/的空间怎么样吗?
- 奇怪!为什么没人回答我啊,我可是小MM啊~~~~~~~各位大哥帮帮忙拉~~~~~
- 连接postgresql数据库的问题!
- 如何配置apache+mysql+php4.0
- 还是关于【关于php数组排序的问题?】
- 如何确定远程服务器的路径
以下为数据库代码select `account`,`ship_country`,count(*)
from (select `account`,`ship_country` from `1_sale_orders` where date(`upload_date`)='2013-09-20' group by `order_id`) group by `account`,`ship_country`
while($row = mysql_fetch_assoc($rs)) {
$res[$row['account']][] = join(',', $row);
}
得到的 $res 是一个二维数组
foreach($res as &$r) $r = '"' . join('","', $r) . '"';
$s = '((' . join('),(', $res) . ')';$s 就是你要的了
'AMZ_AC' => Array ( 'DE:17', 'ES:1', 'FR:236', 'GB:214', 'IT:1' ),
'CO_AC' => Array ( 'JP:216' ),
);foreach($ar as $k=>$r) {
foreach($r as $v) echo "$k => $v<br>";
}AMZ_AC => DE:17
AMZ_AC => ES:1
AMZ_AC => FR:236
AMZ_AC => GB:214
AMZ_AC => IT:1
CO_AC => JP:216