Problems with sorting by column headers
My page was working fine, until I added the sorting per this tutorial: http://www.webassist.com/tutorials/How-to-enable-sorting-of-dynamic-data
This is not the live page ... I copied the page before adding the sorting server behavior. Please see PM because I removed the security from this page so you don't have to log in.
There is no error on the live site, but when I browse the file locally, I get this:
Notice: Undefined variable: WADAusers in C:\xampp\htdocs\numeroset\edit_acct.php on line 56
Fatal error: Uncaught Error: Call to a member function getColumnVal() on null in C:\xampp\htdocs\numeroset\edit_acct.php:56 Stack trace: #0 {main} thrown in C:\xampp\htdocs\numeroset\edit_acct.php on line 56
<?php
$sortWADAusers_1 = new WA_MySQLi_Sort("WADAusers","",false);
if ((((isset($_GET["sort"]))?$_GET["sort"]:"") != "")) {
$sortWADAusers_1->setSort("".($WADAusers->getColumnVal("acct_number")) ."","ASC",true,true);
}
?>
Line 56: $sortWADAusers_1->setSort("".($WADAusers->getColumnVal("acct_number")) ."","ASC",true,true);
*******UPDATE********
The sorting is working now, but as soon as the pagination starts, the sort is lost. How can I keep the pagination working AND keep the sort order working along with it?
Thank you.
