使用JavaScript在新标签页（而不是新窗口）中打开一个URL(Open a URL in a new tab (and not a new window) using JavaScript)

 我认为你需要先使用查询： 
 
select Item,Color,GROUP_CONCAT(Size) as SIZE,GROUP_CONCAT(Qty) as Qty from --tablename-- group by Item,Color
 
 然后使用php while循环来获得您的结果 
 
while($num=$result){
$item=$num['Item'];
$Color=$num['Color'];
$size=explode(",",$num['SIZE']);
$size_show="";
$qty=$num['Qty'];
$qty1=explode(",",$qty);
foreach($size as $key=>$val){
$qty2=$qty1[$val];
$k=1;
while($k<=$qty2){
$size_show.="".$val." ";
$k++;
}

}

echo $size_show;
}
 
 请注意，我只给出了这个想法，并没有测试过代码 

I think you need to first use the query: 
 
select Item,Color,GROUP_CONCAT(Size) as SIZE,GROUP_CONCAT(Qty) as Qty from --tablename-- group by Item,Color
 
Then use php while loop to get your result
 
while($num=$result){
$item=$num['Item'];
$Color=$num['Color'];
$size=explode(",",$num['SIZE']);
$size_show="";
$qty=$num['Qty'];
$qty1=explode(",",$qty);
foreach($size as $key=>$val){
$qty2=$qty1[$val];
$k=1;
while($k<=$qty2){
$size_show.="".$val." ";
$k++;
}

}

echo $size_show;
}
 
Please note that i have given only the idea, and have not tested the code