Julian
|
Posted: 06/05/2004, 11:07 AM |
|
hello,
I create a category->subcategory.->subcategoryN table(unlimited subcategories).
I have problem in ordering to display category1->Subcategory1->Subcategory2 e.t.c.
what I am trying to do:
Grid : Cities
Europe
-> Italy
-> Germany
-> France
-> -> Paris
-> -> Lyon
America
etc...
Any ideas welcome
Thank you
|
|
|
ghtracey
Posts: 23
|
Posted: 06/07/2004, 2:31 PM |
|
Try the following style query, which will sort in the correct order for grouping.
select city, county, continent from cities order by continent, country, city
_________________
Graham Tracey
Council of Yukon First Nations |
|
|
|