[RESOLVED] Limiting a selection

[vertmonkee]

I have a table in my database that contains fields relating to addresses. What I want to do is to give the user a choice to view all the locations from a certain county. As there can be multiple instances of a county in the table how do I ensure the county only gets displayed once.

For example in the table I may have 5 entries which are:

Devon
Cornwall
Devon
Devon
Sommerset

When I retrieve all the information from the table I want to display only

Devon
Cornwall
Sommerset.

I hope this is clear.

Any help is appreciated.
Thanks

[Piranha]

In your SQL use "group by" like this:

$sql = "select * from country group by country;";

If you want to order it as well use that as well. I am not sure if group by or order by should be first, you have to try it out. If you want to order it the other way use desc instead of asc.:

$sql = "select * from country group by country.country order by country.country asc;";

[vertmonkee]

Thanks very much.

It has worked a treat. I had to put the order by after the group by.

Cheers.