I've added two new meta_keys to the
And I need to be able to get both of these values within a single row, along with the
ROW - (user_id) 220 | (bid_user_lat) 45.099080 | (bid_user_lng) -140.09099
Now comes the tricky part ... I then need to use these values within a calculated radius statement:
( 3959 * acos( cos( radians( @lat ) ) * cos( radians( **bid_user_lat.meta_value** ) ) * cos( radians( **bid_user_lng.meta_value** ) - radians( @lng ) ) + sin( radians( @lat ) ) * sin( radians( **bid_user_lat.meta_value** ) ) ) ) AS distance
In the end, I'm making sure that the user is within a certain radius, and if so, I will return it within the query.
But the most important part is being able to query the
wp_usermeta the way I need to!