Combining two meta_values within one row with query

You can use the WP_User_Query class which works much like WP_Query.

The docs: http://codex.wordpress.org/Class_Reference/WP_User_Query

Below is a dump of the WP_User object that it will return, in this example using: 

$wp_user_search = new WP_User_Query( array( 'fields' => 'all_with_meta' ) );
$get_users = $wp_user_search->get_results();

user var_dump

This should set you in the right direction because it was not obvious how your new meta_keys are set up and exactly how you want to run the query. The second question isn’t really related to WordPress 🙂

If you don’t want to use WP_User_Query you will have to use $wpdb which is more direct mySQL query.

it would be something like:

global $wpdb;
$get_map_user = $wpdb->get_results("SELECT * from $wpdb->usermeta WHERE meta_key = 'bid_user_lat'");

It would probably be better if you had one meta_key with 2 values for your long/lat, instead of 2 meta keys.

http://codex.wordpress.org/Class_Reference/wpdb

Related Posts:

  1. Search custom post type by meta data
  2. How to display liked posts of current user in wordpress?
  3. Filter query posts by the count of metas for a meta key
  4. Save default value for empty or missing post meta
  5. Grouping related postmeta data via SQL query
  6. Select User by Joining Multiple Meta Value Results
  7. mySQL query. ORDER BY meta_key
  8. Remove posts from query for events whose start date has passed
  9. Query metas (and not : query posts by metas)
  10. Issue with using add_rewrite_rule() for post querying custom fields
  11. Plugin will sort users by usermeta
  12. Problem when try to add ++1 for user meta
  13. Query posts according to specific post meta values
  14. Order by meta value pro first then meta value free in my search function
  15. How to exclude posts for current user
  16. Query Nickname rather than Display Name in custom Woocommerce plugin
  17. WP_User_Query with more than two custom meta values
  18. get_post_meta with WP_query
  19. Declaring a var, placing it in a query and using the output of the query?
  20. Compare User meta_value with Product meta_value
  21. How to do WP_User_Query for Nested Array value Inside Nested Array field
  22. How to do a sql like query on serialized data of user meta data
  23. Is there any way to get all custom posts and all custom terms with it’s meta in few queries?
  24. Sort by postmeta on when searching
  25. Use $wpdb->get_results with filter based on array
  26. Querying users by meta value and getting a strange answer
  27. What is the best way to query posts based on live data?
  28. Update vs Insert logic but the last key is always inserted?
  29. Custom MySQL Query for Post and Post Meta
  30. Sort users by custom user meta value
  31. list or get meta_key where meta_value is ‘something’
  32. order by numeric value for meta value
  33. how to get list of all users and their metadata
  34. Content hooks vs User hooks
  35. Getting all user metadata from user
  36. What is the most efficient way of implementing a favorite post system?
  37. Why does get_the_time(‘F j’) return November 30 for all posts?
  38. Query by one meta_key and sort by another (possibly NULL value)
  39. WPDB Multiple site’s posts and get featured images
  40. Query & Sort Comments by custom comment meta
  41. is_archive() doesn’t work on public query var archive pages?
  42. How to count get_users query?
  43. Possible to get posts from multiple meta keys/values in a single query?
  44. Difference between fragment caching and wp_cache
  45. How to display all posts with today’s same month and day only?
  46. Is it possible to store visitors IPs in wp_postmeta table?
  47. Using $wpdb->update but confused on the WHERE in and SET
  48. You have an error in your SQL syntax – Help with query
  49. Make one query for adding entries to database
  50. add_query_arg() and empty variables inside
  51. Query Strings and Woocommerce
  52. Style Post Differently In Query
  53. get_*_meta doesn’t always return an array
  54. WordPress post type “event” query string fix?
  55. Get Meta Key Value While Saving Post
  56. mysql query two database tables, users and usermeta and sort by custom meta int value
  57. order one custom post type by modified time of another post type
  58. Creating user status mode in WordPress
  59. Is there a way to append meta data without creating a race condition?
  60. is_search called incorreclty
  61. Nested loop : wich way/order?
  62. How to combine two get_users() array?
  63. Post with certain term and without any term
  64. Custom Query – Based on user input
  65. get_users with array as meta_value
  66. Valid SQL query return empty
  67. mysql query – how to escape apostrophe?
  68. exclude pingbacks from wordpress SQL query
  69. is_main_query() never called on WP 4.4
  70. wp_posts query slowing down my website
  71. Get the_field of Advanced Custom Fields in a custom query [closed]
  72. How do I sort a WP_USER_QUERY by multiple meta fields?
  73. Advanced Custom Fields – Relationship post foreach query
  74. using update_user_meta to rank users
  75. Meta box with front-end styling
  76. How do I query for posts by custom meta and those that have been stickied?
  77. Select min/max meta from query
  78. Creating a custom post type upon registration for a specific user role
  79. Restore WordPress Backup Locally?
  80. Trouble migrating custom post types from non-wordpress cms
  81. “order” does not affect order of custom query
  82. Create a new post on a specified publish date via link?
  83. Exclude Posts from a Widget
  84. New custom post type entries are not sorted correctly in admin using pre_get_posts
  85. Query String for the WP_QUERY parameters
  86. $wpdb query for price in custom field value
  87. Extend WP_User_Query or WP_User to return all custom fields?
  88. Multiple terms not working on taxonomy
  89. Sorting of coupons in the right way
  90. excludeCat function reverses order of blog posts
  91. wordpress simple post multi rating with post_meta and user_meta
  92. Run search query again without pagination gives no results?
  93. WP_Query orderby meta key/value suddely stopped working
  94. Query posts by meta value and sort by another meta key
  95. Where can I find the SQL to get the most used information by wordpress database?
  96. WooCommerce Total # orders [closed]
  97. How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
  98. update $wpdb one query
  99. Admin Post List table Query filtering “WHERE” for custom post type
  100. How to use a dynamic term id for the query block
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)