I came across an interesting question the other day. A user wanted to know how to query a specific number of sticky posts for the front page. Generally, I just point people to the Definitive Sticky Posts Guide for WordPress, but this question was not covered.
The problem:
- User has many sticky posts (maybe 100s).
- User wants to only show a specific number of those ordered by date.
Some of you may be thinking that this should be extremely simple. But, let me warn you, I thought the same thing at first. I had to actually put on the ol’ thinking cap for this one.
Get the latest x number of sticky posts
I’ll assume you already have The Loop set up in one of your template files (i.e., home.php, custom-page.php). What we need to do is call up a specific number of stickies. For this example, we’ll load the two latest sticky posts.
Place this code before your Loop:
<?php
/* Get all sticky posts */
$sticky = get_option( 'sticky_posts' );
/* Sort the stickies with the newest ones at the top */
rsort( $sticky );
/* Get the 2 newest stickies (change 2 for a different number) */
$sticky = array_slice( $sticky, 0, 2 );
/* Query sticky posts */
query_posts( array( 'post__in' => $sticky, 'caller_get_posts' => 1 ) );
?>We have to use rsort() to sort the sticky posts in reverse order by post ID (newer posts first). The reason for this is because sticky posts are added to the sticky array according to when they were made sticky, not by ID.
We have to set caller_get_posts to 1. Otherwise, we’d get all stickies added.
The biggest problem here is that you have to add Updated: Hat tip to Nathan Rice for the $sticky[0], $sticky[1], $sticky[2], and so on. But, typing a few extra characters is a small price to pay for the functionality it offers.array_slice() solution.
Other solutions for sticky-post issues?
As more users start taking advantage of sticky posts, there’ll probably be more issues such as this one pop up. Have you run into any problems querying sticky posts in a certain way? If so, how did you figure it out?
I hope this tutorial at least helps some of you out when working with sticky posts. If you have a more elegant solution for the issue posted above, I’d love to see the code.
Just curious, I haven’t tested this, but using the “limit” parameter on query_posts won’t work? I assume that due to the trouble you went through to write this up, it didn’t work, but I wanted to check anyway.
Nathan Rice — I couldn’t get
limitto work. Even if it did, we’d still need to sort the sticky posts.The problem seems to come from using
post__inbecause we’re specifying the posts we want. I can’t find a way to limit it when specifying all the stickies.@Justin,
Yeah, that makes sense.
BTW, using array_slice on the stickies array will help you reduce some code. Instead of explicitly doing $sticky[0], $sticky[1], etc. you could just do:
$sticky = array_slice($sticky, 0, 3);3 of course would be the limit for the number of stickies you’d want to return with the loop.
Then you could just do this:
A little harder to follow, but much more efficient. You could probably even consolodate the first 2 lines.
I think this would be extremely nice to see in Hybrid.
When Hybrid News came out I started converting all my featured posts to sticky posts, but alas they just all started showing up in the slider. This could be a fantastic way to re-actualize the sticky post as a featured one.
Nathan Rice —
array_slice()was just what I was looking for. I can’t believe I didn’t think of that. It certainly makes things more efficient. Updating the post now.Thomas Clausen — Definitely. When I originally coded Hybrid News, I hadn’t planned on allowing sticky posts for the slider. It was a last minute addition and nothing like this had been tested against it.
If a blog has that many sticky posts perhaps using sticky posts is not the best solution. It might be easier to place the posts into a special category and then query the category to display them.
Just a thought.
LGR — Agreed. I think the main problem here is that users will make a post sticky but will forget to go back and un-sticky it later. So, they end up with way too many sticky posts.
The best way to help users manage them would for the sticky posts to show at the top of the Edit page in the WordPress admin. That way, users could easily find them.
[...] Get the latest sticky posts in WordPress [...]
When you need to show the latest post marked as sticky, you can simply change
rsort()forarray_reverse(). It will preserve the array, only reversing its order.Another thing: for the case you and Nathan solved, we don’t need the
rsort()/array_slice()thing. I think this can be done usingquery_posts:$sticky, 'caller_get_posts' => 1, 'orderby' => ID, 'showposts' => 1));
?>
Damn. Again:
$sticky = get_option( 'sticky_posts' );
query_posts( array( 'post__in' => $sticky, 'caller_get_posts' => 1, 'orderby' => ID, 'showposts' => 2 ) );
@eduardo,
If you look at the comments above, Justin said that the
showpostsparameter didn’t do what it was supposed to do.@Nathan,
Yeah, I know, but it did work for me, really. Worth a shot.
[...] Get the latest sticky posts in WordPress [...]
Hi-
Awesome tip. I’m trying to display the either the (1) latest sticky post, or, if there aren’t any, just the latest post. But the loop is plopping down the latest sticky post AND the latest post. As noted, the showposts option only seems to limit non-sticky posts. Any suggestions?
How can I specify which category I want to get the sticky posts from?
[...] Get the latest sticky posts in WordPress [...]
@two7s_clash: I was struggling with this also and found this solution in a thread started by Nathan. Basically, put everything between a conditional
iftag to check if there are actually any sticky posts available. So, in your case, you would do something along the lines of the following:This is problematic in that two loops will have to be declared (at least I think), but it’s the only way around the problem.
Cheers,
Philip
[...] Get the latest sticky posts in WordPress [...]
I confirm @Edouardo, showposts parameter work fine. Array solution seems to be cleaner.
[...] Get the latest sticky posts in WordPress [...]
Is it possible to list sticky posts in the sidebar?
[...] Get the latest sticky posts in WordPress [...]
[...] Get the latest sticky posts in WordPress [...]
This is working great thanks!
I do have a question though and I’m hoping you will respond to this Justin.
I need to loop 2 times through the same sticky query as I need to create first an unordered list of some custom field value from each stick post and then again to get the title and excerpt out of each. It works fine but the page loads too slow. I’d like to show you if possible by providing a link-would you mind giving me a hand in finding out why the results load so slow?
[...] Get The Latest Sticky Posts [...]
[...] Get The Latest Sticky Posts [...]
Thank you SO much – it worked like a charm
(WP 2.8.3)
I started converting all my featured posts to sticky posts, but alas they just all started showing up in the slider. This could be a fantastic way to re-actualize the sticky post as a featured one.
[...] Justin Tadlock link [...]
[...] 15.Get The Latest Sticky Posts [...]
[...] Tutorial: Latest Sticky Posts http://justintadlock.com/archives/2009/03/28/get-the-latest-sticky-posts-in-wordpress [...]
[...] Letzte Sticky Posts darstellen http://justintadlock.com/archives/2009/03/28/get-the-latest-sticky-posts-in-wordpress Tweet This!Share this on TechnoratiSubmit this to NetvibesAdd this to Mister WongMark this on [...]
[...] Get The Latest Sticky Posts [...]
[...] credit to this code goes to Justin Tadlock and partially to Nathan Rice for coming up with the array slice [...]
Here again, a sizeable body of research literature shows that improvement between treatment sessions is the rule rather than the exception, with the majority of clients in successful therapy experiencing significant symptomatic relief earlier versus later in the treatment process. ,
Anyone know how to add something after the sticky posts?
so if sticky, show after all stickys and before normal posts. if no sticky, show before normal posts?
[...] Get the latest sticky posts in WordPress I came across an interesting question the other day. A user wanted to know how to query a specific number of sticky posts for the front page. Generally, I just point people to the Definitive Sticky Posts Guide for WordPress, but this question was not covered. (tags: Get the latest sticky posts in WordPress) Possibly related posts: (automatically generated)101 Techniques for a Powerful CMS using WordPressFor lost Second Lifers…My another blog [...]
[...] Get the latest sticky posts in WordPress [...]
[...] best solution I found for how to display a WordPress sticky post was a comment by Eduardo on Justin Tadlock’s post Get the Latest Sticky Post. He gave the following code: [...]
[...] credit to this code goes to Justin Tadlock and partially to Nathan Rice for coming up with the array slice [...]