Prev / Next links skip missing database records.
Im trying to make my own blog. Currently I have coded it myself and combined it with phpbb.
Now when someone clicks on a blog post I want to have links to the previouse / next posts.
For example like how wordpress has it.
But note I do not use wordpress I coded this myself so my forum members can comment with there accounts on the blog.
Basically I know how to make a next and previouse link.
But the problem is sometimes I'll need to remove a post ore deleted it.
Now of course if I do this a gap will appear between posts.
So for example this are the records in my database: 1 , 2 , 5 , 7
Now the way I made my next and prev links was to connect to my database select the id and put that idea at the end of my $_GET variables.
index.php?page=($row['id']+1); // next
index.php?page=($row['id']-1); // prev
Now everyone can see that this will not work when I remove a record in the database.
If someone knows how I can solve this ore has a tip please let me know.