I have an array of post ids which I'm passing to query_posts using 'post__in'.
My question is how can I use the order from my array rather than ordering by 'date' etc?
2
-
1order by what??Bainternet– Bainternet2011-08-11 17:31:17 +00:00Commented Aug 11, 2011 at 17:31
-
do the answers to this question help? [wordpress.stackexchange.com/questions/27832/…djb– djb2011-10-22 10:52:58 +00:00Commented Oct 22, 2011 at 10:52
Add a comment
|
1 Answer
You would need to build your own query and pass it to query_posts i.e.
if your array of post ids is:
array (10,21,1) // corresponding to post ids.
then you can query this way:
select * from wp_posts where `ID` in (10, 21, 2)
order by field(ID,10,21,2)
This will give you a result set in the order of your post ids array.
HTH
-
This is a great way to accomplish this. If you don't want to sacrifice the benefits of using query_posts, you can also chain into the
posts_orderbyfilter to alter the orderby and use FIELD(ID, ...). Furthermore, to keep it dynamic, you can use, for a given array $arr,'FIELD(ID, '.implode(',',$arr).')'. See the Codex for a good writeup of the posts_orderby filterMatthew Boynes– Matthew Boynes2012-01-28 15:13:12 +00:00Commented Jan 28, 2012 at 15:13