sort data retrieved from sql

[fizzwizz]

I have a set of data containing the addresses of my customers.

I want to list the counties that my customers come from .... Now I can list all the counties like so ...

$result = mysql_query("SELECT * FROM retailers",$link_id);
				while($query_data = mysql_fetch_row($result))
				{

			   if ($query_data[5]) echo $query_data[5]:
			}

$querydata[5] countains data from column 5 ie all the counties.

What I need is a way of listing the counties without repeating any

ie at the moment i get

Avonshire
Yorkshire
Avonshire
Bedfordshire
Bedfordshire
Avonshire

but I just want

Avonshire
Bedfordshire
Yorkshire

How can I do this?

[laserlight]

read the docs on using the DISTINCT keyword in SELECT queries.

[fizzwizz]

AHH, brilliant ... That's the puppy.

$result = mysql_query("SELECT Distinct county FROM retailers",$link_id);
				while($query_data = mysql_fetch_row($result))
				{			
				   if ($query_data[0]) echo $query_data[0];
				}

Many Thanks