{"id":324,"date":"2010-07-20T15:24:45","date_gmt":"2010-07-20T15:24:45","guid":{"rendered":"http:\/\/keithdevon.wpengine.com\/?p=324"},"modified":"2010-07-20T15:24:45","modified_gmt":"2010-07-20T15:24:45","slug":"sorting-wordpress-posts-using-surnames","status":"publish","type":"post","link":"https:\/\/keithdevon.com\/sorting-wordpress-posts-using-surnames\/","title":{"rendered":"Sorting WordPress Posts Using Surnames"},"content":{"rendered":"

A client recently requested that their ‘Members’ page be sorted by surname and not first name. The lists were generated using the follwing code:<\/p>\n

<?php$cat_args = array(<\/pre>\n
'sort_column' => 'post_title',<\/pre>\n
'order' => 'ASC',<\/pre>\n
'parent' => 12);<\/pre>\n
$categories = \u00a0 get_categories($cat_args);<\/pre>\n
foreach($categories as $category) {<\/pre>\n
echo '<ul id=\"member\"><li><h3>' . $category->name.'<\/h3><\/li>';<\/pre>\n
$post_args = array(<\/pre>\n
'numberposts' => 50,<\/pre>\n
'orderby' => 'title'<\/span>,<\/span><\/pre>\n
'order' => 'ASC',<\/pre>\n
'category' => $category->term_id\u00a0\u00a0 \u00a0);<\/pre>\n
$posts = get_posts($post_args);<\/pre>\n
foreach($posts as $post) {\t?><\/pre>\n
<li><a href=\"<?php the_permalink(); ?>\"><\/pre>\n
<?php the_title(); ?><\/a><\/li>\t<?php\t}<\/pre>\n
echo '<\/ul>';<\/pre>\n
}<\/pre>\n
?><\/pre>\n
To sort by surname I created a custom field in the Post Edit screen. The name of the custom field I set to ‘surname’ and I entered the member’s surname in the value field.<\/p>\n
I then had to change the PHP code to look for the custom field and sort the list accordingly. I changed the\u00a0‘orderby’ => ‘title’<\/span>,<\/span> to <\/span>‘orderby’ => ‘meta_value’,’meta_key’ => ‘surname’,<\/span>.<\/span><\/span><\/p>\n
Now the members are sorted by their surnames.\u00a0Simple! View the code in action here<\/a>.<\/p>\n
Note: If the custom field of ‘surname’ is not given a value then the post title will not display in the list.<\/p>\n","protected":false},"excerpt":{"rendered":"
A client recently requested that their ‘Members’ page be sorted by surname and not first name. The lists were generated using the follwing code: <?php$cat_args = array( ‘sort_column’ => ‘post_title’, ‘order’ => ‘ASC’, ‘parent’ => 12); $categories = \u00a0 get_categories($cat_args); foreach($categories as $category) { echo ‘<ul id=”member”><li><h3>’ . $category->name.'<\/h3><\/li>’; $post_args = array( ‘numberposts’ => 50, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[12],"tags":[35,47,49],"acf":[],"_links":{"self":[{"href":"https:\/\/keithdevon.com\/wp-json\/wp\/v2\/posts\/324"}],"collection":[{"href":"https:\/\/keithdevon.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/keithdevon.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/keithdevon.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/keithdevon.com\/wp-json\/wp\/v2\/comments?post=324"}],"version-history":[{"count":0,"href":"https:\/\/keithdevon.com\/wp-json\/wp\/v2\/posts\/324\/revisions"}],"wp:attachment":[{"href":"https:\/\/keithdevon.com\/wp-json\/wp\/v2\/media?parent=324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/keithdevon.com\/wp-json\/wp\/v2\/categories?post=324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/keithdevon.com\/wp-json\/wp\/v2\/tags?post=324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}