[eluser]mabright[/eluser]
Thanks
WanWizard. I was searching through the PHP Array functions and this is just what I was looking for, works perfectly.
tonanbarbarian,
I will try to merge the queries, I initially thought of this but wanted to keep the functions separate. I have a custom library for all my GEO location related functions which uses a location model and external APIs. My venue related data is in my venue model which is where my venue query happens and I do not want to add GEO location logic to this model.
I think I will break down the state/city array and build a string of states and a string of cities and pass this to the "get_venues" function instead of a single city and state.
This would make the query as:
Code:
SELECT * FROM `venue`
WHERE UPPER(`city`) IN ('SAN JOSE','ATLANTA')
AND UPPER(`state`) IN ('CA','GA');
