[RESOLVED] Match array key to query match

[zzz]

I have an array that I output through a loop. It's a list of states. Now I need to run a query ona table and if I find any results associated with this state in db mark this table with, say <strong>State</strong> tags.

Having difficulties figuring it out. I'd hate to run a query 50 times to get the results... There's gotta be a better way.

[reddrum]

Not sure if I understand but maybe try the 'like' operator in sql "like $state[1] or like $state[2] ...?

[zzz]

No... I need to get existing States from db and then match to a full list from array. I decided I'll save the query results into an array ans then try to match by using in_array PHP function. Let's see if taht works.

[reddrum]

Somthing like this?

found_states = array();

   foreach($state as $chkState){
      if (in_array($chkState, $string)) {
         found_state[$i] = $chkState;
         ++$i
      }
   }

[zzz]

Yep. It works great.