sorting dynamic data

I have followed the tutorial by Kate Ford to create a link on a column header that will sort a table by that column. I have been able to get this working properly but it fails when using the navigation buttons. I have not been able to find (or understand) the fix that keeps the sort order over multiple pages. I am using Data Bridge 2.3.4 and mySQLi. Any help appreciated.

Can I see a copy of the page you are working on? If I could get a URL and FTP access, that would be best.

I'm working on my local machine and do not have a database or files set up on a web server. This is not a priority at this time so maybe I can get back to you after I've uploaded files. I thought maybe this was a known situation with a common fix.

What happens when you navigate to a new page? What version of the rsobj.php file do you have? I'm sure there is an easy fix, but I need to understand the issue better in order to help.

rsobj.php version 2.25... it's hard to explain what it's doing... I'm testing with paging set at 10 records and I have a total of 12 records in the table. When I click on my link it sorts the the first page correctly but going back and forth between page 1 and 2 can produce seemingly random results. Probably the best thing to do is revisit this when I get something on the web server.

Are you passing a url parameter to do the sort? It is probably keeping it in the url and causing the sort to turn on and off, or switch order. You can tell the recordset to not include the url parameter in the navigation links with code like:

<?php

$Recordset1->RemoveParams[] = "sort";

?>

Just add it below the recordset making sure to use your recordset name and the url parameter you want to be removed from the navigation links.

Looks like that did it Ray! I'll let you know if I note any quirks as I add data but it looks good now. Thank you.