Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › WA_MySQLi_Sort Class in rsobjphp

WA_MySQLi_Sort Class in rsobjphp

Thread began 3/13/2017 10:52 am by Dave Buchholz | Last modified 3/13/2017 2:21 pm by Ray Borduin | 510 views | 2 replies |

3/13/2017 10:52 am | #1 Dave BuchholzBeta Tester

WA_MySQLi_Sort Class in rsobjphp

I have a need to sort a recordset based on the value of a checkbox and looking through rsobj.php I found the above mentioned class. So I have the following set up with is working

$sort_rsProductListing = new WA_MySQLi_Sort("rsProductListing","");
if ("" == "") {
  $sort_rsProductListing->clearSort();
  if(isset($_GET['productListing']) && ($_GET['productListing'] == 0)){
   $sort_rsProductListing->setSort("pkCategory, CommonBrandName, SeriesName, SKU, StandardColor","ASC",false,true); 
  } else {
    $sort_rsProductListing->setSort("CommonBrandName, SKU, StandardColor","ASC",false,true);
  }
}

but I suspect I am not taking advantage of the full power available, so is there anything I can do to improve on this ?

3/13/2017 2:12 pm | #2 Ray BorduinWebAssist

I suppose that is fine if it works for you. I'm not sure if it would have an issue when coupled with navigation. It might be better and a little simpler to just use:

php:

$sort_rsProductListing = new WA_MySQLi_Sort("rsProductListing","CommonBrandName, SKU, StandardColor");

if (isset($_GET['productListing'])) {

   $sort_rsProductListing->setSort("pkCategory, CommonBrandName, SeriesName, SKU, StandardColor","ASC",false,true); 

}

Did this help? Tips are appreciated...

3/13/2017 2:19 pm | #3 Dave BuchholzBeta Tester

Thanks Ray, looking forward to the release of the updated behaviours to see how all these things work together.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.