Posted by DS2 Systems on 09/29/07 04:40

Try:
SELECT DISTINCT City from Events;

"Ron Eggler" <NOREPLY@example.com> wrote in message
news:EpgLi.251710$fJ5.1185@pd7urf1no...
> Hi,
>
> I would like to place a mysql select query but avoid double entries.
> I have a table with events from a city, there's more than one even in one
> city so the city appears multiple times. Now i want to select the city
> first and in a second run i'm gonna read all the events from this city.
> How would i do this, how would the select statement look like? Or do i
> need
> to get it all back and ditch multiple entries in php?
>
> Thanks!
> Ron

[Back to original message]