trouble with query to fetch next and previous posts

Try:

$arrPosts = $wpdb->get_results($sql);

That said, note that there also is an API to get these two. See in particular:

get_next_post()
get_previous_post()

Related Posts:

  1. posts_per_page no limit
  2. Alternative to query_posts for main loop? [duplicate]
  3. Query posts by custom taxonomy ID
  4. How to return results of a get_posts() in explicitly defined order
  5. Query posts: how to exclude results if post is in multiple categories
  6. query_posts ->using meta_compare / where meta value is smaller or greater or equals
  7. How to order posts by descending comment count on taxonomy page?
  8. Is it better practice to use query_posts, WP_Query, or get_posts to create various custom loops within a Page?
  9. WP 5.8 “Query Loop” block: where to place custom query?
  10. Sort X categories by last update and show image
  11. Pagination on archive.php page
  12. Best way to load page content in Fancybox popup?
  13. order post my meta value m/d/y format with year as included value
  14. _wp_page_template to dynamically use template
  15. Schedule Sticky Posts
  16. Total Count of Posts NOT in Selected Categories?
  17. WordPress Search Filter Only for Page with Child of Child of Child of Child of Child
  18. Problem with single-page for my custom post
  19. How to modify the query to exclude posts by slug?
  20. How to make the list of post and load on same page with sub-pages [closed]
  21. How to get 4 Posts after the 5 most recent ones
  22. post_status => publish not working
  23. How to fetch all posts in a category that were published between two given dates?
  24. How do I make archives.php for one category only?
  25. get_meta_data within a loop
  26. making random query button using $_GET
  27. Is it possible to query_posts using post__in and then Loop through them in the ordered they were queried?
  28. How do I change the default sort order of a custom column on the posts page?
  29. how to exclude “featured” posts from the main loop?
  30. WordPress pagination showing same posts on each page
  31. pass query string on url to filter media
  32. Order posts by condition
  33. Co-authors plus problems with query_post
  34. Error sending array of inputs
  35. Search breaks when querying main loop for category
  36. Authors List page – How to include only those with wp_user_level as Author
  37. Adding conditional content to single post-type template
  38. Simple custom post query for all the posts or many of them not working
  39. Hook to return true when the_post() is used in a custom while loop
  40. Query posts by meta_key whose value is an array
  41. How to remove a plugin filter’s priority on specific loops (custom queries)?
  42. Proper syntax to add boolean in array()
  43. get_the_title outputs title until spacing; it does not get full length of title
  44. using query_posts to pull posts out of a category in a while loop. Getting odd echo
  45. Echo a numerical value in query_posts
  46. why to use query_posts() in custom page?
  47. Query posts to get all but the most recent post
  48. Always using the same ARRAY on different querys
  49. Display trimmed version of the_post()
  50. Currently using a query_posts() in my theme – want to use a request filter in stead
  51. How do I use pagination in WordPress?
  52. Breadcrumbs stop working on a specific template file
  53. Does WordPress run a post query when a page is invoked?
  54. How exclude 3 latest posts of a category in query_posts
  55. Multiple posts/pages in one page?
  56. Order for custom field after the loop
  57. Custom post query error
  58. Multiple instances of query_posts
  59. Different layout based on post amount?
  60. If Query Post Returns 1 Post
  61. How to check a list or feed of all posts under a category and tag?
  62. Calling Posts from Specified Cat
  63. Keeping get_posts’ offset and is_paged() synchronized
  64. odd behaviours from template tags
  65. How do I add a timezone offset to this query?
  66. query_posts thumbnail condition
  67. Show posts from specific roles
  68. How to add an “or” instead of and “and” (&) in a WordPress query?
  69. Instead of 4 loops, how can I do it better?
  70. How to get any type posts include attachments by ids?
  71. Modify main loop query for paged and meta key
  72. wordpress query_posts featured page always on top
  73. Create a Loop with Posts Ordered by Most Recent Comments
  74. Need to add a space after meta value in query_posts in wordpress for zipcode search
  75. Tax query get first product with attribute value in pre_get_posts
  76. Help with query_posts function
  77. Specifying image size used in template the_content
  78. allow user to edit posts made by others users based on the user role
  79. Ordering Posts By Meta Data
  80. No duplicate tags by category
  81. Order posts by ACF checkbox
  82. Post per page not working
  83. Show previous month’s posts
  84. why is pre_get_posts not working
  85. query_posts result differs from wp_query request result
  86. If meta_key has value = 6 | Change the wp_posts.post_date to current date
  87. Query posts based on parents attribute
  88. Adding Category Argument into an Array for WordPress Query
  89. orderby not working for query_posts using array of IDs
  90. Collect posts from last 48 hours
  91. The_content display a different content from a previous loop
  92. How to go to tag archives using a form
  93. Run second query on page based on author of the first query
  94. WordPress loop problem: Multiple loops, index.php and is_paged causing duplicate posts on next page
  95. Why doesn’t this page query work?
  96. Including post data in a sidebar occurring outside of and before the Loop
  97. Resetting a Query using wp_reset_query() or wp_reset_postdata() does not work
  98. Sort posts with multiple meta_keys
  99. How to get custom post type posts with certain multiple tags names and category id?
  100. Create “archives by year and week” by category template