Hello everyone,
I have some code like this:
$query = "SELECT M.BEGINNING_INVENTORY AS BEGINNING_INVENTORY,
S.MATERIAL_CODE AS MATERIAL_CODE, S.MATERIAL_NAME AS MATERIAL_NAME,
SUM(S.IMPORTATION_QUANTITY) AS SUM_IMPORTATION,
SUM(S.EXPORTATION_QUANTITY) AS SUM_EXPORTATION FROM STOCK_INFORMATION AS
S LEFT JOIN MATERIALS AS M ON M.MATERIAL_CODE = S.MATERIAL_CODE WHERE
S.MATERIAL_NAME != '' GROUP BY M.MATERIAL_NAME ";
$results2 = mysqli_query($db, $query);
<thead>
<tr>
<th>Material Code</th>
<th>Material Name</th>
<th>Beginning Inventory</th>
<th>Sum(Importation)</th>
<th> Sum(Exportation)</th>
<th>Remainder</th>
</tr>
</thead>
<tr>
<?php
if(isset($results2) ) {
while($row1 = mysqli_fetch_array($results2)) {
global $db;
?>
<td><?php echo $material_code1 = ($row1['MATERIAL_CODE']); ?></td>
<td><?php echo $material_name1 = ($row1['MATERIAL_NAME']); ?></td>
<td><?php echo $beginning_inventory = ($row1['BEGINNING_INVENTORY']); ?></td>
<td><?php echo $sum_importation = ($row1['SUM_IMPORTATION']); ?></td>
<td><?php echo $sum_exportation = ($row1['SUM_EXPORTATION']); ?></td>
<td><?php echo $net = (($beginning_inventory + $sum_importation) - ($sum_exportation)); ?></td>
</tr>
<?php }} ?>
</table> Also, in this file I have another code like this:
$search_query = "SELECT SUM(RESULT) AS FINAL, MATERIAL_NAME, UNIT, MATERIAL_TYPE
FROM(
SELECT P.PRODUCT_NAME AS PRODUCT_NAME, SUM((B.ACTUAL_QUANTITY *
P.PRODUCT_QUANTITY)) AS RESULT
,B.MATERIAL_NAME AS MATERIAL_NAME,B.ACTUAL_QUANTITY, B.PRODUCT_CODE AS
PRODUCT_CODE,B.UNIT AS UNIT ,B.MATERIAL_TYPE,B.BOM_NAME FROM BOM AS B LEFT
JOIN PRODUCTION_PLAN AS P ON P.PRODUCT_CODE = B.PRODUCT_CODE AND
P.BOM_NAME = B.BOM_NAME WHERE MATERIAL_NAME <> '' GROUP BY MATERIAL_NAME,
PRODUCT_CODE ) AS RESULT GROUP BY MATERIAL_NAME ";
$results = mysqli_query($db, $search_query);
<thead>
<tr>
<th>Material Name</th>
<th>Requirement </th>
<th>Inventory</th>
</tr>
</thead>
<tr>
<?php if(isset($results) ) {
while(($row = mysqli_fetch_array($results))) {
global $db;
?>
<td><?php echo $material_name = ($row['MATERIAL_NAME']); ?></td>
<td><?php echo number_format($row['FINAL'],0); ?></td>
<td><?php
global $material_name1;
global $net;
if($material_name == $material_name1){
echo $net; } ?>
</td>
</tr>
<?php }} ?>
</table>I want to have the remainder ($net) from the first table in front of every material_name from the second table. (It must be compatible with material_name). How to do it? Now, I have just one of them.
Thanks in advance
Regards