日期:2014-05-17 浏览次数:20462 次
<?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] =>