[Support request] Change the post navigation order…

[Yannick]

Thanks Tom. I saw that URL and it doesn’t work.
Seems like my only solution will be to add a leading zero and have it parsed before being displayed…

[Tom]

It may be worth asking over on https://wordpress.stackexchange.com just in case someone else has a solution.

[Yannick]

I installed Query Monitor to have a look at the get_adjacent_post() query, and what seems to be the issue, is that WP queries the database with a WHERE clause based on the date. So it’s looking for a post with a greater or lesser date than the current post, and limits it to 1 (which is the logical way of doing it).

In my case, I need to change the WHERE query to find the previous or next post in the DB, based on the title. I see how I can change it and can technically check if p.post_title > $post->post_title, but again, it won’t work with natural sorting…

Arghhhh, haha!

[Author]

Posts