Sort Posts by Multiple Meta Values [duplicate]

Since I couldn’t find the way to grab the custom post’s title and add it to the sorting/ordering by meta_key, I edited my custom post type to include a hidden field that grabs the title of the post and sets it as a custom meta value when the user adds a new custom post. So, in my custom post type plugin, I have:

<input type="hidden" name="buy_location_name" value="<?php echo get_the_title($buy_location->ID); ?>" />

if ( isset( $_POST['buy_location_name'] ) && $_POST['buy_location_name'] != '' ) 
 { update_post_meta( $buy_location_id, 'location_name', get_the_title($buy_location_id) ); }

And then on the frontend page that posts the results sorted by State, City and finally Store name, I use the example code found in this URL: http://wordpress.mcdspot.com/2012/10/24/sort-posts-on-multiple-custom-fields/

My code starts like so…

$meta_keys = array('store_state','store_city','location_name');
$args = array(
    'post_type' => 'buy_locations',
    'meta_key' => $meta_keys[0],
    'orderby' => 'meta_value',
    'posts_per_page' => -1);
$my_query = new WP_Query($args);

And then later on, ends with…

usort($my_query->posts, 'sort_3_keys');
while ( $my_query->have_posts() ) : $my_query->the_post();
$id = $post->ID;
$storestate = $id_array[$id][$meta_keys[0]];
$storecity = $id_array[$id][$meta_keys[1]];
$storename = $id_array[$id][$meta_keys[2]];
echo "$storestate | $storecity | $storename <br />";
endwhile;

In summary, the cat who developed this code (http://wordpress.mcdspot.com/2012/10/24/sort-posts-on-multiple-custom-fields/), is one bad muthah and I’m grateful for his work and for him sharing it. This has helped me achieve the results I needed. Cheers.

Related Posts:

  1. How to query_posts using meta_query to orderby meta_key AND have a secondary sort by date?
  2. Using database meta_values to calculate new post order using pre_get_posts or a ‘request’ hook
  3. Using meta_query, how can i filter by a custom field and order by another one?
  4. How to return results of a get_posts() in explicitly defined order
  5. Sort posts alphabetically by custom field value, insert divider between different letters
  6. Sort X categories by last update and show image
  7. Sorting problem with ‘query_posts’ funcion in wordpress. Sort by custom field not working
  8. query_posts sort in multiple directions
  9. get_post_meta causes database queries
  10. Order by meta_key with two meta_queries
  11. ACF Custom Field WP_Query, but need to get all posts, if field doesn’t exist
  12. Order posts using a custom array
  13. orderby:date not working
  14. Single meta key with multiple meta value in like comparison
  15. Filter Loop by Custom Field Value
  16. meta_query check for meta value in key which holds an array of values
  17. Meta query stopped working
  18. Custom query looking at multiple custom fields and properly sorting
  19. Tax query get first product with attribute value in pre_get_posts
  20. Ordering Posts By Meta Data
  21. query_posts() with multiple meta data comparisons
  22. wp_query by last month + sort posts
  23. If meta_key has value = 6 | Change the wp_posts.post_date to current date
  24. posts_per_page no limit
  25. Nested meta_query with multiple relation keys
  26. ORDER BY custom field value
  27. Sorting: custom query with orderby meta_value_num THEN by title
  28. Query posts by custom taxonomy ID
  29. Query posts: how to exclude results if post is in multiple categories
  30. query_posts ->using meta_compare / where meta value is smaller or greater or equals
  31. How to order posts by descending comment count on taxonomy page?
  32. WP 5.8 “Query Loop” block: where to place custom query?
  33. Meta Query with date and time on the same Day before given time
  34. Pagination on archive.php page
  35. order post my meta value m/d/y format with year as included value
  36. _wp_page_template to dynamically use template
  37. Schedule Sticky Posts
  38. Advanced orderby with multiple meta_query
  39. WordPress Search Filter Only for Page with Child of Child of Child of Child of Child
  40. Problem with single-page for my custom post
  41. Used with meta_query in query_posts works slowly
  42. How to make the list of post and load on same page with sub-pages [closed]
  43. How to get 4 Posts after the 5 most recent ones
  44. Sorting posts by multiple values, combined
  45. post_status => publish not working
  46. How to fetch all posts in a category that were published between two given dates?
  47. get_meta_data within a loop
  48. how to exclude “featured” posts from the main loop?
  49. pass query string on url to filter media
  50. Order posts by condition
  51. Co-authors plus problems with query_post
  52. Error sending array of inputs
  53. order posts by meta value on posts page
  54. Search breaks when querying main loop for category
  55. How to display multiple custom fields with the same meta_key in an ascending order?
  56. Help ordering Post loop by two meta values
  57. Adding conditional content to single post-type template
  58. Query posts by meta_key whose value is an array
  59. using query_posts to pull posts out of a category in a while loop. Getting odd echo
  60. Currently using a query_posts() in my theme – want to use a request filter in stead
  61. How do I use pagination in WordPress?
  62. Querying multiple values from a single key
  63. Breadcrumbs stop working on a specific template file
  64. change the default order of posts only for specific categories
  65. Meta_query ‘compare’ => ‘LIKE’ not working?
  66. Order for custom field after the loop
  67. Custom post query error
  68. Why doesn’t my WP Meta Query return any results?
  69. Multiple instances of query_posts
  70. Different layout based on post amount?
  71. If Query Post Returns 1 Post
  72. How to check a list or feed of all posts under a category and tag?
  73. Keeping get_posts’ offset and is_paged() synchronized
  74. odd behaviours from template tags
  75. How to get any type posts include attachments by ids?
  76. Modify main loop query for paged and meta key
  77. wordpress query_posts featured page always on top
  78. Create a Loop with Posts Ordered by Most Recent Comments
  79. How to order query results based on if a custom field has been populated, then the order by the date of the post?
  80. Need to add a space after meta value in query_posts in wordpress for zipcode search
  81. Specifying image size used in template the_content
  82. allow user to edit posts made by others users based on the user role
  83. Pagination not working on my archive page for a custom post type
  84. Custome column sort by date not title
  85. Order posts by ACF checkbox
  86. query_posts with sorting on a custom datestamp
  87. Post per page not working
  88. Show previous month’s posts
  89. query_posts result differs from wp_query request result
  90. Query posts based on parents attribute
  91. Adding Category Argument into an Array for WordPress Query
  92. Collect posts from last 48 hours
  93. The_content display a different content from a previous loop
  94. How to go to tag archives using a form
  95. Run second query on page based on author of the first query
  96. WordPress loop problem: Multiple loops, index.php and is_paged causing duplicate posts on next page
  97. Why doesn’t this page query work?
  98. Sorting not working with get_posts
  99. Sort posts with multiple meta_keys
  100. Create “archives by year and week” by category template