Another multidimentional array question

[eluser]tonanbarbarian[/eluser]
your simplest option all round would be to grab all the data in one query using joins rather than in multiple queries

1 query is always better than dozens
dont know how many cities the first query is likely to find, but if it could potentially find hundreds you are going to have hundreds of queries being run