Re: query from two tables
| From: | DL Neil | Date: | Tue, 05 Feb 2002 12:42:51 +0000 |
| Subject: | Re: query from two tables | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16483@lists.php.net to get a copy of this message | ||
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 order the query
> by cities? I have tried multiple selection like select ads.*, cities.*
> from ads, cities , but it returns a nonsense.
> Any help would be appreciated
Are you looking for an ORDER BY clause to sequence the rows of the resultset?
=dn