Re: [PHP-DB] query from two tables

2002-02-04 Thread DL Neil
Hi Balazs, The situation: I have 2 tables in an adverising site. In one table, i have the cities used by advertisers, and in the other there are the ads.This ad table has a field which refers to the id of the city in that table. The problem: what mysql method should i use if i want to

RE: [PHP-DB] query from two tables

2002-02-04 Thread Rick Emery
JOIN adverts a using(city_id) ORDER BY city; -Original Message- From: Ivan Balazs [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 6:26 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] query from two tables Hi! The situation: I have 2 tables in an adverising site. In one table, i