Member Avatar for joshmac

I was wondering if the following was possible with a query? If so, can someone give me an example query? I want to print a list of products, group them by color, and then have the totals at the end of each group.

| Color | Product |
-------------------
| Blue  | Case    |
| Blue  | Vase    |
| Blue  | Coat    |

Total: 3

| Red   | Care    |
| Red   | Cover   |

Total: 2
  • 2 Contributors
  • 3 Replies
  • 129 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by joshmac
Member Avatar for joshmac

If anyone has another solution, or if the answer is just plain no or can't be done, I would be ok with that answer as well.

Edited by joshmac
Member Avatar for pritaeas

Not with a single query.

Member Avatar for joshmac

@pritaeas thanks.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.