Home > Backend Development > PHP Tutorial > 数组合并排序问题

数组合并排序问题

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-23 14:12:23
Original
920 people have browsed it

本帖最后由 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 />';?>
Copy after login


得到的结果:

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        ))
Copy after login

如何将这些二维数组合并到一个数组中并按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 排序
Copy after login
Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template