Listing same data once

[Anon]

Hello,

I'm trying to list repetative data once.
For example: I'm trying to list all the cities but there are rows with the same cities, so it will list like:

Denver
Denver
Denver
Seattle
Seattle

and I want it to read

Denver
Seattle

is this possible?
thanks for the response.

-Soo-

[rrijnders]

If your records are in a database and you only want a list of the cities in that database then,

$sql = "SELECT city_field FROM whatever_table GROUP BY city_field";

but if your goal is to output other information in the table but only output the city once, like:

Name City
============ =========
John Doe Atlanta
Mke Hunt

Mano Amano Boston

Then you have to do that with code to check if the current city name is the same as the last city name you printed.

-- Rich Rijnders
-- Irvine, CA US

[steved]

select distinct cityname from yourtable