
August 20th, 2003, 02:51 AM
|
|
Junior Member
|
|
Join Date: Aug 2003
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Select Distinct Command
I have a database with the following values:
Item A, Boa, Snakes
Item B, Boa, Snakes
Item C, Boa, Snakes
Item D, Python, Snakes
Item E, Python, Snakes
Item F, Collubrid, Snakes
I want the output to look like this though:
Snakes
--> Boas
--------> Item A
--------> Item B
--------> Item C
--> Pythons
--------> Item D
--------> Item E
--> Collubrid
--------> Item F
How do I structure this in CFML to give me this output?
|