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



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to