|
|
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'
Navigation:
[Reply to this message]
|