Recordset Navigation Bar Issue
I have an index page with a dynamic drop-down menu where you select the state. Then you hit submit and it goes to my results page where a dynamic table displays all record from my table with the selected state. I finally got that all to work just fine.
Here's the problem: I have a Recordset Navigation Bar system set up on my results page, and can get the first page of results to work correctly, but the navigation system doesn't work. When you page Next, the page doesn't populate, and you cannot get back to the original page or either of the first or last pages.
Here's the code that DW generated for the Recordset Navigation Bar if it helps:
<table border="0">
<tr>
<td><?php if ($pageNum_rsFiberIntake > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsFiberIntake=%d%s", $currentPage, 0, $queryString_rsFiberIntake); ?>">First</a>
<?php } // Show if not first page ?>
</td>
<td><?php if ($pageNum_rsFiberIntake > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsFiberIntake=%d%s", $currentPage, max(0, $pageNum_rsFiberIntake - 1), $queryString_rsFiberIntake); ?>">Previous</a>
<?php } // Show if not first page ?>
</td>
<td><?php if ($pageNum_rsFiberIntake < $totalPages_rsFiberIntake) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsFiberIntake=%d%s", $currentPage, min($totalPages_rsFiberIntake, $pageNum_rsFiberIntake + 1), $queryString_rsFiberIntake); ?>">Next</a>
<?php } // Show if not last page ?>
</td>
<td><?php if ($pageNum_rsFiberIntake < $totalPages_rsFiberIntake) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsFiberIntake=%d%s", $currentPage, $totalPages_rsFiberIntake, $queryString_rsFiberIntake); ?>">Last</a>
<?php } // Show if not last page ?>
</td>
</tr>
</table>
Any suggestions would be greatly appreciated. Thanks!
