Posted by macca on 09/29/07 02:10

On Sep 29, 12:48 am, Ron Eggler <NORE...@example.com> wrote:
> 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


Sounds like an SQL question to me.

You should ask in comp.databases.mysql.

You want something like:

SELECT * FROM events WHERE city='some_city'

[Back to original message]