WordPress.org

1. newboi
   Member
   Posted 5 months ago #

   Hi All,

   I have a query that returns results with duplicates. e.g.

   +---------------+-----------------+
   | Type          |  Price          |
   +---------------+-----------------+
   | Music         |  19.99          |
   | Music         |   3.99          |
   | Music         |  21.55          |
   | Toy           |  89.95          |
   | Toy           |   3.99          |
   +---------------+-----------------+

   My problem is how to group the products by type, so that it returns a single product type and total price for each product type e.g:

   Music | 45.53
   Toy | 93.94 and so on.

   Many thanks for your help in advance

   Cheers!

Reply

You must log in to post.