Support » Fixing WordPress » Group Query result

  • newboi

    (@newboi)


    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!

  • The topic ‘Group Query result’ is closed to new replies.