My website is currently under construction but is being based around DBman..

http://www.tenerife-property.com/timeshare/index.html

I have an imagemap on the default page of the world where you can make a basic search by clicking through on a continent (Europe works) and a short list of results is displayed along with a click through to the appropropriate record..

I want to alphabetically sort the COUNTRY..

Location is made up of three seperate fields
location1, location2, location3...
1 being continent, 2 being country, 3 being region..

Please take a look at the URL and tell me if this is possible and how i go abouts doing it.. I´ve searched the forums, and yes there are many posts relating to sorting results but not really any I could use..

Help appreciated... Justin

Thanks for your reply LoisC, I don´t really understand whats going on in that above message, its a bit confusing.. Is there an easier way round this or another posting that might make more sence..

Thanks... Justin

Justin:

Take a look at this thread as I think it may gives you some ideas of how to go about doing this.

Alphabetical Category Search and More - http://www.gossamer-threads.com/scripts/forum/resources/Forum12/HTML/001110.html
multi-tiered approach. And a count.

If I remember correctly this is related to what you are wanting to do.

Justin, I think this is a simple thing, if I understand you correctly.

When I did the search, I got:

Europe, Canary Islands, Tenerife.
Europe, Spain, Malaga.
Europe, Canary Islands, Tenerife.
Europe, England, Sussex.
Europe, Scotland, Glasgow.
Europe, France, Paris.
(and some others, but this is enough for demonstration purposes)

If I understand you correctly, you want:

Europe, Canary Islands, Tenerife.
Europe, Canary Islands, Tenerife.
Europe, England, Sussex.
Europe, France, Paris.
Europe, Scotland, Glasgow.
Europe, Spain, Malaga.

Yes?

If so, all you need to do is add something to your search link. I played around a little at your site and found that your field that includes the country (Location2) is field 5. So you just need to add

&sb=5

to your search link.

You have more than you need in your search links. This will work and will be a whole lot shorter:

...db.pl?db=default&uid=default&Location1=Europe&mh=10&sb=5&view_records=1





------------------
JPD