配列のマージソートの問題

この投稿は、lazygc520 によって 2013-06-07 09:37:32 に最終編集されました

<?php$sql = "select DISTINCT b.packageno,a.stock_no from `stock_detail` as a,`kw_manage` as b where a.stock_no = '".$stockno."' and a.cust_no = replace( b.cust_no, ' ', '' )";$result = mysql_query($sql);while($row = mysql_fetch_array($result,MYSQL_ASSOC)){	$sql2 = "select lotno,count(lotno) from `vp_barcode_2d_y` where packageno = '".$row['packageno']."' group by lotno order by lotno asc";	$result2 = mysql_query($sql2);	$var = array();	while($row2 = mysql_fetch_array($result2,MYSQL_NUM))	{		$var[] = array('lotno'=>$row2[0],'count'=>$row2[1]);	}	print_r($var);	}//	echo $a[$k]['5'].'<br />';?>

得られた結果:

Array(    [0] => Array        (            [lotno] => 3207            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3207            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3206            [count] => 12        )    [1] => Array        (            [lotno] => 3207            [count] => 3        ))Array(    [0] => Array        (            [lotno] => 3207            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3207            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3218            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3218            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3218            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3218            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3218            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3218            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3218            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3218            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3218            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3218            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3218            [count] => 15        ))Array(    [0] => Array        (            [lotno] => 3218            [count] => 15        ))

これらの 2 次元配列を 1 つの配列にマージし、lotno で並べ替えるにはどうすればよいですか?
Lotno が同じ場合、対応するカウント値を加算します。どうやって対処すればいいのでしょうか？

ディスカッションへの返信 (解決策)

$sql = "select DISTINCT b.packageno,a.stock_no from `stock_detail` as a,`kw_manage` as b where a.stock_no = '".$stockno."' and a.cust_no = replace( b.cust_no, ' ', '' )";$result = mysql_query($sql);$res = array(); //设置一个用于存放结果的数组while($row = mysql_fetch_array($result,MYSQL_ASSOC)){    $sql2 = "select lotno,count(lotno) from `vp_barcode_2d_y` where packageno = '".$row['packageno']."' group by lotno order by lotno asc";    $result2 = mysql_query($sql2);    $var = array();    while($row2 = mysql_fetch_array($result2,MYSQL_NUM))    {       if(isset($res[$row2[0]])) $res[$row2[0]]['count'] += $row2[1];       else $res[$row2[0]] = array('lotno'=>$row2[0],'count'=>$row2[1]);    }}ksort($res); //因键名已处理成 lotno 的值，所以按键名排序就是按 lotno 排序