You want to use the Haversine formula
http://en.wikipedia.org/wiki/Haversine_formula
This plugin might be of interest to you:
http://wordpress.org/extend/plugins/wp-geoposts/
Provides WP_GeoQuery an extended WP_Query class for doing distance based and geo-aware queries.
it uses the Haversine formula here:
http://plugins.svn.wordpress.org/wp-geoposts/trunk/query.php
Related Posts:
- Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
- Sorting: custom query with orderby meta_value_num THEN by title
- Sort posts by category name and title
- How to get order of posts?
- How to get Page/Post Gallery attachment images in order they are set in backend using WP_Query()?
- WP Query orderby meta key natural sort?
- Loop through all tags & output posts in alphabetical list
- Sorting Posts by custom field
- Sorting meta_value as integer doesn’t work
- Sort in WP_Query(), not filter? Is it possible?
- Front End Sorting Questions
- Woocommerce custom loop to show all the products [closed]
- Sort by meta key on archive page
- How to sort posts in admin by titles with dd.mm.yyyy format?
- Query Set Order By Author
- WordPress: Keep order of query_posts list of post ID’s using post__in
- How to make orderby ‘meta_value_num’ OPTIONAL?
- Meta query with order by another custom field
- How to orderby meta_value_num with dollar ($) sign
- How do I sort posts with multiple pages
- Changing WP_Query params with url Query Var
- Sort wordpress custom posts based on meta value
- WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
- WordPress Comments sort by custom meta key
- Understanding the orderby in WP_Query?
- WP_query sorting can’t sort danish letters (æ, ø, å)
- Help ordering Post loop by two meta values
- How to sort a custom wordpress query by combination of meta values?
- Gallery shortcode numerical sorting
- WP Group posts by year(desc) > month(desc) > date(asc)
- Does wp track views for posts?
- Sort WordPress Posts Meta value by Week not Day
- How to order WP_Query to group results?
- I am having problem sorting custom post type using WP_Query
- Sorting search results with custom dropdown
- How to use a dropdown to filter posts by custom field
- Display all posts in a custom post type, grouped by a custom taxonomy. How to sort the posts alphabetically and the terms by ID?
- How do I sort this custom list of sticky posts
- WP Query and date format
- How to sort queried pages by an array of page ids?
- orderby ignored by wp_query
- Customize the Sorting Dropdown in WooCommerce use another list or more page
- Order (by ASC) posts with meta_key so posts without values are last
- How to sort store location by specific category order in WP store locations
- how to include orderby value that is empty?
- How to sort wordpress posts already selected by WP_QUERY
- Sort by price wpdb
- Custom Woocommerce Product Query
- How sort products by calculate value? ( custom post meta, price, option)
- Get authors list and sort them by recent posts
- Move some posts to end of sort order, even if there is a sort in the wp_Query already
- Order by value of Custom Field using url string
- WP Query with meta queries
- Order 2 meta_queries differently in WP_Query?
- Case insensitive ORDERBY in wpquery
- Sort posts on custom field AND after that sort on date?
- How to mix two orderby-parameters into one ordered result
- Sorting Posts by Taxonomy thats not within the query’s $args
- Ignoring ‘a’ when sorting posts
- Display three sequential posts on each page load, without repeating previous
- Combine WP_Query with array of custom data to single loop without breaking the pagination
- Wrap group of wp query posts to parent div by date/year
- Sorting posts by meta values: 2 different orders
- Sorting is not working in WordPress WP_Query
- How to sort a WP_Query array by post_name after an array_merge();
- Sorting: custom query with orderby meta_value_num THEN by title
- query_posts with sorting on a custom datestamp
- Sort Posts with custom meta key by default which is currently set as optional
- wordpress sorting using array merge by price in ascending order but price with 0 must be show last
- have_posts order by title descending
- WP_Query – order with usort by custom meta
- Sort by multiple columns using get_posts
- Way to include posts both with & without certain meta_key in args for wp_query?
- How can I use WP-CLI commands without –allow-root
- meta_query not working properly
- Using tax_query reverses my post_type argument in a custom WP_Query
- creating wp query with posts with specific category
- $wp_query->current_post restarts from zero on paged pages
- How to do a query on custom taxonomies that is uncategorised?
- Database Queries Optimization with new WP_Query
- Sort entries by date mixing two post types
- Order ascending is ignored in meta query?
- Custom Pagination in Shortcode with WP_Query
- WP Query – Post Thumbnail
- Link Author URL’s based on a custom field
- wp-query, pull children of parent page
- How to change tag based on metabox value within $wp_query
- What’s missing in this wp_query and meta_query
- Tax Query on product_cat using NOT IN as operator does not exclude that category
- How to use the Term Object from a custom select field in a query
- Random users always showing same 8 users
- How to sort by multiple values in a nested WP_Query
- Wp-query and column blocks
- Display 3 levels of categories on page
- Showing most popular post of week
- The sorting of posts by a meta_query with two keys fails while separated as single queries it works
- Hierarchical List Pages as a table
- WP_Query with several meta_query-statements and order by meta_value
- Second wp_query doesn’t appear to be working
- post__in not recognizing multiple IDs