WordPress – query 5 posts with a specific post in top

You can do this by using get_adjacent_post() and the filter get_previous_post_where or get_next_post_where. You’ll call get_adjacent_post() as normal, but you’ll need to change the LIMIT to 5, using the filter.

I wasn’t sure from the question whether or not you wanted to have the current post be first. If you do, you’ll need to set the LIMIT to 4 and then use the current postdata to generate the first post.

I would create an array of post ids, and then use get_post() when you iterate through them, as I believe that get_adjacent_post() will return raw rows from the database.

Related Posts:

  1. The correct method to pass query vars in AJAX using ajaxurl
  2. How to search display_name column when using WP_User_Query
  3. wpdb::prepare was called incorrectly
  4. How to order WP_User_Query results to match the order of an array of user IDs?
  5. Alter query on edit.php
  6. How to find objects by terms
  7. How to create a WP_Query to search the Title or Tag?
  8. How to order posts by modified date without using ‘query_posts’?
  9. How to get user by display_name with WP_User_Query
  10. Specific Loop For 2 Within Each
  11. WP database error for comments_popup_link()
  12. How to add a post or page tag to the list of classes appearing in the body tag’s class attribute?
  13. my function doesn’t return my post from today
  14. Display related products with custom output
  15. Get ID of child from child slug, while knowing parent ID
  16. List User order by ID in Descending order (Backend)
  17. How to get to a specific position in wp_query?
  18. Multiple choice in a custom taxonomy
  19. Get all user meta by meta key instead of ID
  20. Why is variable not working on custom sql query using wpdb?
  21. Get stock by custom meta field on all Woocommerce variable products
  22. Any possible way to make $wpdb->get_results() return anything else than array?
  23. Custom filter in admin edit custom post type responding with invalid post type?
  24. Echo a hierarchical list of post data from custom fields
  25. WP Query with custom Shortcode
  26. mysql query from wordpress page using custom table
  27. WordPress 3.2 query_posts and pagination, permalinks issue
  28. only show container with next/prev links if they exist?
  29. What query string parameter is available for index.php, that works for both pages and blog articles?
  30. Increase offset while looping
  31. Long running queries
  32. wpdb php get_var query to get ID for URL image doesn’t work for ID over 999
  33. How to pre populate a form field with a link of a current user’s author profile?
  34. Two queries for a WP_User_Query search work perfectly apart, but not together
  35. Trying to get a PHP variable defined in a custom post into a javascript file. Null value. Using wp_localize_script
  36. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  37. register_taxonomy() take much queries
  38. Which is the correct way to conditionally enqueue a CSS file?
  39. Odd / Even posts add class minus first post
  40. unable to use ‘new WP_Query’ in AJAX call
  41. Parse error: syntax error, unexpected ‘}’ on get_the_author_meta [closed]
  42. How to list commenters and days since last commented
  43. How to add div blocks after certain set of post
  44. Can’t update multiple rows with $wpdb query
  45. working with term_relationships table
  46. WordPress query undefined offset in loop
  47. Can I make get_users() query global?
  48. Issue with custom loop in Archive page
  49. How to display SQL query that ran in WC_Order_Query?
  50. Custom Post type slider with thumbnail navigation
  51. Parse error: syntax error, unexpected ‘}’ [closed]
  52. PHP -> SQL Query with Summing
  53. How to hide posts of a specific custom category in WordPress?
  54. WordPress PHP syntax doesn’t seem to be working correctly
  55. How to get thumbnail with pure PHP in a WordPress database?
  56. Why my query does not run with prepare
  57. mySQL queries are executed twice on wordpress website
  58. List of Events with Multiple Dates: Only NEXT Date
  59. Echo array value
  60. Change Query Arguments (filter) with jQuery/Ajax or PHP?
  61. Display latest post from WordPress Featured Category that is also in X,Y,or Z categories
  62. Query pulling a single post per month
  63. WordPress Custom Query: Combining Two Functions
  64. SQL error with custom query
  65. WordPress Conditional / Multiple Taxonomy Query
  66. How can I modify this code to make the search box include tags and meta
  67. Reject all malicious URL requests functions.php
  68. Advanced Query posts
  69. How can I check that the acf field value is not a duplicate when adding a post?
  70. My Custom Post Type AJAX Query is Returning no posts – why?
  71. array wordpress when get is null
  72. Why does a header location on admin_head remove the query var I’m setting in the location?
  73. getting the values of hidden inputs to use them in a php mysql query
  74. Offset with ajax load more posts duplicates
  75. Let user select the number of posts shown per page jquery error
  76. Query doesn’t display text data with apostrophes
  77. How to query a staging database?
  78. How to make a parent page for author.php?
  79. Include a custom field in mysql query
  80. Echo multiple tasks if a common function exists
  81. How to enqueue assets only on queried pages, excluding the page being queried?
  82. “Where… like” query not working as expected
  83. Check if values exists DB
  84. Trying to exclude posts from a category on the home page
  85. Problems With Query and/or Template Part and/or PHP
  86. Arrange Category post manually when displayed
  87. The search engine of my website finds only posts and not pages, how can I solve this problem?
  88. Hide empty categories from get_categories
  89. Query Concatenation
  90. How to insert a variable into a query parameter?
  91. wp_query on search results page showing all results every time
  92. WP_Query not returning results
  93. Can WordPress support Website (19GB database) Should I move Our WordPress Website to a custom one using Laravel or any other PHP framework?
  94. Three different queries on same page
  95. Exclude a category ID from the following function
  96. Custom Filtering date with newsletter
  97. Pre_get_comments and orderby comment_karma
  98. taxonomy pages returning “NULL” when running default WordPress function ‘get_queried_object()’
  99. Hot to show custom post type taxonomies on archive page
  100. Display featured posts first, then display all others within a specific category in WordPress