Array ( [1] => miami [2] => tampa [3] => palmbeach [4] => ftmyers [5] => orlando [6] => jacksonville [7] => naples [8] => bocaraton [9] => ftlaud [10] => daytona [11] => keywest [12] => staug [13] => panamacity [14] => pensacola [15] => fortwaltonbeach-fl [16] => sarasota [17] => gainesville [18] => tallahassee [19] => cocoabeach [20] => stpete ) SELECT city1, artist_id, metro_id, Metro, ST, state_id, State_Prov FROM artistable, lmetros, lstates WHERE ( artistable.city1 = lmetros.metro_id AND lmetros.ST = lstates.state_id AND artistable.artist_id = 'alrr' AND artistable.type = 'd' AND (artistable.status = 'ok' OR artistable.access_key='') ) Resource id #10Array ( [city2] => tampa [artist_id] => alrr [metro_id] => tampa [Metro] => Tampa [ST] => FL [state_id] => FL [State_Prov] => Florida ) Array ( [1] => FL [2] => FL [3] => FL [4] => FL [5] => FL [6] => FL [7] => FL [8] => FL [9] => FL [10] => FL [11] => FL [12] => FL [13] => FL [14] => FL [15] => FL [16] => FL [17] => FL [18] => FL [19] => FL [20] => FL )
Array ( [1] => fl [2] => fl [3] => fl [4] => fl [5] => fl [6] => fl [7] => fl [8] => fl [9] => fl [10] => fl [11] => fl [12] => fl [13] => fl [14] => fl [15] => fl [16] => fl [17] => fl [18] => fl [19] => fl [20] => fl )
Array ( [1] => Florida [2] => Florida [3] => Florida [4] => Florida [5] => Florida [6] => Florida [7] => Florida [8] => Florida [9] => Florida [10] => Florida [11] => Florida [12] => Florida [13] => Florida [14] => Florida [15] => Florida [16] => Florida [17] => Florida [18] => Florida [19] => Florida [20] => Florida )