计算db中的值

Question

I'm looking to upload a cvs into a db and then find how many times an instance of data appears to create a pick list.

I upload a cvs in to the db leaving me with

SKU and QUANTITY

I use to get the data from the db but I cant seam to find a way to group that data so their is only 1 sku for each item and a number of ordered items.

<table border="1" width="100%" id="table1">
<?php
    $query = mysql_query("select * from pickcount");
    while($fetch = mysql_fetch_array($query))
    {
?>
    <tr>
        <td><?php echo $fetch['sku']; ?></td>
        <td><?php echo $fetch['quan']; ?></td>
    </tr>
<?php
}
?>  

</table>

Answer 1

<table border="1" width="100%" id="table1">
<?php
    $query = mysql_query("SELECT sku, SUM(quan) AS Sum_Of_Quan FROM   pickcount GROUP BY sku");
    while($fetch = mysql_fetch_array($query))
    {
?>
    <tr>
        <td><?php echo $fetch['sku']; ?></td>
        <td><?php echo $fetch['Sum_Of_Quan']; ?></td>
    </tr>
<?php
}
?>  
</table>

Try to replace your table structure with above structure and check the result