How to find what index page a post is on?

There’s no way to do it directly but there’s a way to determine the position of a particular row in a mysql query. You can find out how to do it here- https://stackoverflow.com/questions/3614666/mysql-get-row-position-in-order-by

Once you have the position you can divide it with the value from get_option('posts_per_page') to determine the correct page number.

Related Posts:

  1. The next_posts_link() works only with original $wp_query
  2. Query *only* sticky posts
  3. Skipping first 3 posts in wp query
  4. Accessing the post content with WP_Query
  5. Most viewed post for the last 2 days using WP_Query
  6. Adding Post Counts to Menu (Nav) Programmatically?
  7. This AJAX Code Doesn’t Work – Looking for elegant solution
  8. Get only modified posts
  9. How to output comments number of a post per day?
  10. Should ‘setup_postdata()’ be reset with ‘wp_reset_postdata()’?
  11. If specific user role then sticky post
  12. Display posts with comments closed, with pagination?
  13. posts_per_page doesnt work
  14. Blogroll – Different layout for first post
  15. I want to query posts in monthly basis
  16. Loop through all product posts?
  17. Custom WP_QUERY $args
  18. Improving WP_Query for performance when random posts are ordered
  19. Why won’t my taxonomy query show up?
  20. Display post from current category and same tag?
  21. Get Posts that are in the current month or later
  22. WP Query to Get Array of Slugs
  23. How to change the setting so there is no post on home page
  24. WP_Query with ajax handler returns the same posts
  25. Why WP_Query(‘showposts=5’) shows only 1 post?
  26. How can I sort posts by the date and a custom meta field?
  27. Hiding Draft Post In Admin
  28. How to insert 2 args into 1 Wp_Query for a slideshow
  29. Display post option on frontend
  30. How to verify wp user password by sql query in wp? [closed]
  31. WP Query – Posts Per Page not working in combination with category__in
  32. Lost draft under all posts and drafts
  33. Get user categories with most posts in it
  34. how to change the number of posts returned in a specific loop without making it global?
  35. List authors with the last post title and order by last post date
  36. How to order posts by meta_value and title
  37. Redirect to another page using contact form 7? [closed]
  38. Nested WP_Query breaking loop
  39. WordPress query_posts by tag doesn’t work anymore(?)
  40. Why Query is returning empty array?
  41. Ignore latest two posts
  42. Show posts by author of membership level (Paid Membership Pro)
  43. meta_value timestamp older than now
  44. Print out last 3 blogposts
  45. Query for first 3 posts to change the look and feel
  46. Why posts array is empty?
  47. Getting blog pagination to work on page set as front page
  48. How to group only VISIBLE posts? [closed]
  49. How to check in functions.php if there is data in a WP_Query?
  50. Shortcode with ‘year’ parameter
  51. search blog posts by author first name and or last name
  52. On what hook can I get the queried object’s final state?
  53. unique post in “$args” of wp_query display more than one post
  54. How can I insert a new markup element after 4 posts automatically? [closed]
  55. How to display post list in a table layout (multiple queries in single loop)
  56. Not all posts showing in query
  57. Get all custom posts with a certain taxonomy
  58. Link to date_query results in WordPress
  59. When WP_Query only returns 1 post, how do I automatically redirect to that post?
  60. WordPress query portfolio posts
  61. Get latest author posts inside the loop
  62. Limiting post list by taxonomy
  63. Display 3 posts with different HTML markup using a loop
  64. Is there a function to get post info for any publish_status by post ID?
  65. Optimal WP Web App Backend for mobile app development
  66. How to show multiple posts thumbnail, title and date in widget
  67. Post page overwrite the custom blog page
  68. Group first, 2nd, 3rd, etc posts by category terms
  69. Manipulated offset and pagination, can’t display last post anymore
  70. Function is printing twice – any suggestions?
  71. How to display particular set of wordpress post on a webpage?
  72. How to use two query result together in one loop
  73. show loop id post , only first id can read
  74. Counting Posts by Category
  75. show image gallery in archives or category page
  76. Page with Category Returning 1
  77. filter posts based on menu_order
  78. Show 5 posts and than 3 posts offset with pagination
  79. Change archive results based on GET request
  80. Wp_query loop is not working as it should
  81. Show all posts from the tags without having to set all of them
  82. Is it possible to query a category with specified posts?
  83. Creating Ordered Query using Meta_key
  84. Is there a global page/post/product/anything ID?
  85. WordPress loop uses unmodified posts array, why?
  86. wp query custom orderby not custom field
  87. Show posts between two Custom Fields date
  88. Query to get data of a post, if in category?
  89. Order posts by custom field
  90. Why I have this strange behavior when I try to exlude the featured post from posts visualization?
  91. Remove duplicated posts in the loop if post has more than one category
  92. How to Include a common category in a custom Category Search
  93. Why I getting only 1 post?
  94. The next_posts_link() works only with original $wp_query
  95. wp_query posts sorting doesn’t work
  96. Limit amount of pages shown in pagination within wp_query
  97. First post in loop displays twice
  98. Trying to create shortcode listing custom posts, but formating not being included
  99. Get related posts matching most of the provided tags using WP_Query
  100. WP_Query post_tilte search in posts table