SitePoint Sponsor |
|
User Tag List
Results 1 to 11 of 11
Thread: stuck on simple count & format
Threaded View
-
Dec 4, 2009, 14:04 #1
stuck on simple count & format
I have a DB that has the following table
ITEM COLOR
Hat Red
Hat Red
Hat Blue
Hat Orange
Belt Red
Belt Blue
Belt Blue
Belt Orange
I want to query and display results like this:
ITEM - Red - Blue - Orange
Hat - 2 - 1 - 1
Belt - 1 - 2 - 1
Any help is greatly appreciatedRestaurant Takeout & Delivery Menus : Over 4500 Menus Online
Athletic Recruiting & Community for High School Athletes!
Bookmarks