me, a.ad_text FROM city c LEFT 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 adveris
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
Hi!
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 order the query
b
