MySQL: Group by two columns and sum

by

Based on your example table, it appears you want to be grouping on product rather than id. You merely need to add the Size column to both the SELECT list and the GROUP BY

$query = "SELECT 
            product,
            Size, 
            SUM(Quantity) AS TotalQuantity 
          FROM inventory
          GROUP BY product, Size";

Note that I have added a column alias TotalQuantity, which will allow you to more easily retrieve the column from the fetched row via the more sensible $row['TotalQuantity'], rather than $row['SUM(Quantity)']

More Related Contents:

  1. Trying to Show 87 mysql rows in 3 html tables using PHP and mysql [closed]
  2. While loop inserts three times
  3. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in? [duplicate]
  4. Auto Increment ID’s of 4 digit
  5. php nested while loop. Inner loop works only once [closed]
  6. Problame with files on SQL
  7. PDOException “could not find driver”
  8. Row count with PDO
  9. Best way to INSERT many values in mysqli?
  10. How to view query error in PDO PHP
  11. How to populate second dropdown based on selection of first dropdown using jQuery/AJAX and PHP/MySQL?
  12. Resetting array pointer in PDO results
  13. Notice: Array to string conversion in
  14. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  15. Using Mysqli bind_param with date and time columns?
  16. How do I insert multiple checkbox values into a table?
  17. Is mysql_insert_id safe to use?
  18. PDO::PARAM for type decimal?
  19. How to set up entity (doctrine) for database view in Symfony 2
  20. How to execute raw queries with Laravel 5.1?
  21. Can’t find FULLTEXT index matching the column list (indexes is set)
  22. Extension mysqli is missing, phpmyadmin doesn’t work
  23. MySQL and PHP – insert NULL rather than empty string
  24. How to get MySql 8 to run with laravel? [duplicate]
  25. recursive function to get all the child categories
  26. Save Accents in MySQL Database
  27. How do I ensure I caught all errors from MySQLi::multi_query?
  28. Sort by date (newest)
  29. How to write a stored procedure in phpMyAdmin?
  30. mysql count into PHP variable

Leave a Comment