I've created a page where I run my own database queries in conjunction with a separate database table. This process has been described at http://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query
I've now tried to paginate the search results using one of the existing functions, e.g. posts_nav_link(), but it's not working and the 'next page - previous page' links don't appear.
I realise that this could be a problem because this is a page and not a normal search result.
Any ideas how to get the existing pagination function to work?