How to sum the total after filtering the data?

[Jasmin Guila]

<?php
$current = "in";
include("menu.php");
 
echo "<div style='clear: both;'>&nbsp;</div><div style='clear: both;'>&nbsp;</div>";
$result = mysql_query("SELECT s.bin_location, s.shelved_qty, s.issued_qty, r.wh_code, m.component, m.mat_code, m.description, m.uom FROM wms_shelving AS s LEFT JOIN wms_receiving AS r ON s.rm_id = r.rm_id LEFT JOIN bom_material AS m ON r.uid_mat = m.uid_mat WHERE s.shelved_qty > s.issued_qty OR ISNULL(s.issued_qty) ORDER BY m.component, m.mat_code");
 
/*
echo "\n<table id= 'inventory'>";
echo "\n\t<tr class=\"yellow\">\n\t\t<th>Component</th>\n\t\t<th>Item Code</th>\n\t\t<th>Description</th>\n\t\t<th>Bin Location</th>\n\t\t<th>UoM</th>\n\t\t<th>Quantity</th>\n\t</tr>";
while($row = mysql_fetch_array($result))
    {
    echo "\n\t<tr>";
    echo "\n\t\t<td>" . $row["component"] . "</td>";
    echo "\n\t\t<td>" . $row["mat_code"] . "</td>";
    echo "\n\t\t<td>" . $row["description"] . "</td>";
    echo "\n\t\t<td>" . $row["bin_location"] . "</td>";
    echo "\n\t\t<td>" . $row["uom"] . "</td>";
    $remaining_qty = $row["shelved_qty"] - $row["issued_qty"];
    echo "\n\t\t<td>" . $remaining_qty . "</td>";
    echo "\n\t</tr>";
    }
echo "\n</table>";
*/
 
echo "<table id='inventory'>";
echo "<tr class='yellow'>
<th>Component</th>
<th>Item Code</th>
<th>Description</th>
<th>WH Location</th>
<th>UoM</th>
<th>Quantity</th>
</tr>";
while($row = mysql_fetch_array($result))
    {
        $component = $row['component'];
        $itemcode = $row['mat_code'];
        $description = $row['description'];
        $wh_location = $row['bin_location'];
        $uom = $row['uom'];
        $remaining_qty = $row["shelved_qty"] - $row["issued_qty"]; 
      //  $quantity = $row['remaining_qty'];
echo "<tr>";
echo "<td>$component</td>";
echo "<td>$itemcode</td>";
echo "<td>$description</td>";
echo "<td>$wh_location</td>";
echo "<td>$uom</td>";
echo "<td>$remaining_qty</td>";
echo "</tr>" ;
    }
echo "</table>";
?>
</form>
<script language="javascript" type="text/javascript">
    var fnsFilters = {
        sort_select: true,
        loader: true,
        col_5: "none",
        col_4: "none",
        col_3: "select",
        col_2: "none",
        col_1: "select",  
        col_0: "select",
        on_change: true,
        display_all_text: "Filter",
        rows_counter: false,
        btn_reset: false,
        alternate_rows: false,
        btn_reset_text: "Display Existing Item Code",
        col_width: ["auto","auto","auto", "auto", "auto", "auto"]
    }
    setFilterGrid("inventory",fnsFilters);
 
</script>
</body>
 
</html>

[r035198x]

Which total? If it's for your data values like total remaining_qty then just create a variable before the while initialized to zero and add each record's remaining_qty inside the while.

[Jasmin Guila]

i want the total of the remaining_qty.. Sample image below.. [IMG]C:\Documents and Settings\markanthony.uy\Desktop\samp\total2.JPG[/IMG]

[r035198x]

So did you try what I suggested above?

[Jasmin Guila]

yes sir i tried it last time but it doesn't complete my requirements, I study by myself and Im new in coding im so confused kindly help me sir? i can't attached the image can i get your email? so i can send you the image for my output and the image that i want to happen.. i dont really gets some of the code, the code above was coded by other and it was turnover to me for some changes. Thank you sir for your reply and help! really appreciate it more power..

[r035198x]

1.) You need to read more so that you can understand the code you are trying to change.
2.) You need to be able to describe the output you got and the output you expected using just words. All programmers need some level of ability to communicate ideas with others
3.) If I send you my email address then it will open up random videos of Justin Beiber, perform defenestrations on your neighbors' pets with a computer recorded audio shouting "belly button!" at uneven intervals, that wouldn't be nice now would it?

[Jasmin Guila]

ok sir, thanks for your tips.. i do some changes that is close to what i expected.. one more question is it possible to have a barcode generator that is coded in PHP and connected to mySQL?

[r035198x]

Yes it's possible. There are even open source versions created for the task. You'll have to do some reading on them and how to use them. More questions about them should be a new thread though not this one.