[RESOLVED] Loop through array

zzz

I have an array in the following format:

$locality = array(

'AZ' => array
(
	'phoenix' 	=> 'Phoenix'
),

'TX' => array
(
	'austin' 	=> 'Austin',
	'houston' 	=> 'Houston',
	'dallas' 	=> 'Dallas'
)
);

I need to loop through this array and generate a query for each city.

SELECT *
FROM t1
WHERE state = 'STATE FROM ARRAY'
AND city = 'CITY FROM ARRAY'

I have no idea how would I do it with such an array.

johanafm

Creating one question for each state and city to retrieve them all takes longer time than getting it all in one go, so why not do it all at once?

SELECT * FROM t1 ORDER BY state, city

zzz

Oh, sorry I did not make it clear. I need to run a PHP loop, not mySQL. Besides querying db I'll need to build an array for buffer output. So, I'm basically looking at how to do a foreach(x AS y loop with the given array.

NogDog

I would agree that it seems very inefficient to run a separate query for each array element, but then I don't know why you want to do this. If it really is what you need to do, it could be done by a couple nested loops:

foreach($locality as $state => $cities)
{
   foreach($cities as $city)
   {
      $sql = "SELECT * FROM t1 WHERE state = '$state' AND city = '$city';
      // execute query, etc.
   }
}

(And, of course, the $state and $city values should be escaped as appropriate for whatever DB interface you are using.)

zzz

ahh... nested -- never even though about it. It is inefficient, but the script will be run once nightly during low usage, and results will be stored into an include for daily use.