Actually want the functionality of weedmaps.com, via buddy press
I am looking to migrate data from the bp_xprofile_data to a more query-able table schema. I can select the data singly like so:
$address =
SELECT value FROM tdc_bp_xprofile_data WHERE field_id = 3
$city =
SELECT value FROM tdc_bp_xprofile_data WHERE field_id = 4
etc.
and I have a table that each row will be queried and formatted to JSON for GMAPS APPI insertion.
If you have a better solution for Geo -location in buddypressPlease let me know
