文章目录[隐藏]
本帖最后由 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); }// e<p>5本文来源gao!daima.com搞$代!码#网#</p><pre>搞代gaodaima码
cho $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,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 排序
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：数组合并排序问题
转载请注明原文链接：数组合并排序问题
