WordPress.org

Ready to get started?Download WordPress

Plugin Directory

Sort Query Posts

Sort posts on-the-fly without making a new SQL query

A really simple and lightweight plugin (73 lines of code - comments included) to sort posts on-the-fly without making a new query to the database (improves performance).

Features:

  • Supports all order_by and order values of the query_posts function except meta_value and meta_value_num (which require a database query).
  • Supports changing the order of all types of posts, including custom post type posts and custom post type "archive" posts.

Documentation

This plugin adds the function sort_query_posts_by(string $order_by [, string $order]) to the global context. The second $order parameter is optional. Its default value is asc (ascending order).

Call this function before the loop to change how posts are ordered. After calling this function you can show the posts as you normally would.

You can sort posts by:

  • author
  • comment_count
  • date
  • id
  • menu_order
  • modified
  • parent
  • title

This is specially useful in two cases:

  • When you need to reorder the posts returned by the query that WordPress creates from your given URL. Custom post type "archive" posts are a great example of this case.
  • When you need the posts returned by your customized query (e.g. query_posts()) to be shown more than once on the same page and ordered differently.

Examples:

<?php sort_query_posts_by('title', 'desc'); ?>

The example above will sort posts by their title in descending order without making a new query to the database. This way sorting is performance friendly.

<?php sort_query_posts_by('ID'); ?>

The example above will sort posts by their ID in ascending order.

<?php sort_query_posts_by('rand'); ?>

The example above will sort posts randomly. When sorting randomly $order is ignored.

Plugin developed by Túbal Martín at http://www.margenn.com.

Requires: 2.5 or higher
Compatible up to: 3.4.2
Last Updated: 2012-9-4
Downloads: 9,280

Ratings

5 stars
5 out of 5 stars

Support

0 of 2 support threads in the last two months have been resolved.

Got something to say? Need help?

Compatibility

+
=
Not enough data

0 people say it works.
0 people say it's broken.

100,1,1 100,1,1
100,1,1
100,1,1
100,1,1
100,1,1
100,1,1
100,1,1
100,1,1
100,1,1
100,3,3
100,1,1
100,3,3
100,1,1
100,1,1
100,2,2