数组合并排序问题两个数组合并排序的java实现

本帖最后由 lazygc520 于 2013-06-07 09:37:32 编辑

$row2[0],'count'=>$row2[1]);	}	print_r$var);	}//	echo $a[$k]['5'].'
';?>

得到的结果:

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        ))


如何将这些二维数组合并到一个数组中并按lotno排序?
若lotno相同时,将对应count的值相加。请问下如何处理?

回复讨论解决方案)

$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,countlotno) 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))    {       ifisset$res[$row2[0]])) $res[$row2[0]]['count'] += $row2[1];       else $res[$row2[0]] = array'lotno'=>$row2[0],'count'=>$row2[1]);    }}ksort$res); //因键名已处理成 lotno 的值,所以按键名排序就是按 lotno 排序

Published by

风君子

独自遨游何稽首 揭天掀地慰生平

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注