So, I have a repeater field with locations in them. What I’m trying to do is make a query so when I put into a search box in google maps, for example, “Los Angeles, CA” or an address it geocodes it and then search into the database for nearby locations (haversine formula via https://developers.google.com/maps/articles/phpsqlsearch_v3).
The problem I’m having is how the data is presented in the wp_postmeta. It looks something like this:
post_id, Store_Location_Repeater_0_Location
post_id, Store_Location_Repeater_1_Location
post_id, Store_Location_Repeater_2_Location
…
post_id, Store_Location_Repeater_100_Location
I’m not quite sure how to just pull relevant data from the database. Thanks!
