So I have this array that consists of
array (size=3)
0 =>
array (size=2)
'id' => string '46' (length=2)
'ship_product_code' => string '122' (length=6)
'purchase_order_number' => string 'PO-1' (length=4)
1 =>
array (size=2)
'id' => string '47' (length=2)
'ship_product_code' => string '123' (length=6)
'purchase_order_number' => string 'PO-2' (length=4)
2 =>
array (size=2)
'id' => string '50' (length=2)
'ship_product_code' => string '124' (length=6)
'purchase_order_number' => string 'PO-2' (length=4)
I wanted to echo a table that is based on the Purchase Order Number. So by given above array, how can I create a table that is like following:
PO-1 //PO Number
122 // Product Code
<tr> <td> </td> </tr>//another td for space
PO-2 //PO Number
123 // Product Code
124 // Product Code
How can I "group" the result based on the Purchase Order Number?? Have been dealing with it quite a while, keep searching, but can't really find any resource to achieve so.
I have following code that work but not perfectly
if(count($products)>0){
$i=0;
foreach($products as $v){
$PDFCONTENT .= '<tr>
<td align="center" width="7%"> </td>
<td align="center" width="50%">'.$v['purchase_order_number'].'</td>
</tr>';
$i++;
$PDFCONTENT .= '
<tr>
<td align="center" width="7%">'.$i.'</td>
<td align="center" width="50%">'.$v['ship_product_code].'</td>
<td align="center" width="7%">'.number_format($v['qty']).'</td>
<td width="7%"> </td>
</tr>
<tr>
<td></td>
</tr>
';
}
}
above code will produce following table
PO-1
122
PO-2
123
PO-2
124
Please note that I edited the array data here, so I can be more straightforward. There is no problem in outputting the data. Only how can I group the based on the PO Number.
Thank you so much for the help :)