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