sorting icons

Hey Ray

On the attached product_resuuults page, I have a sort for each column.

In the title row (starting line 266) there are 6 column titles each with an arrow pointing down

<a class="glyph sortArrow" href="product_results.php?sort=ProductName"><i class="icons-arrow-down"></i></a>

how would i get this to be changed onclick to

<a class="glyph sortArrow" href="product_results.php?sort=ProductName"><i class="icons-arrow-up"></i></a>

and then back again when clicked again?

It appears you have attached the wrong page. This page doesn't have the code you referenced on it and doesn't have any sort functionality.

sorry here you go

I had to add a new method to the MySQLiSort object to make this easier to do. I've gone ahead and updated your live page with the correct files and syntax. I only implemented the CategoryName column. You should be able to copy that syntax for the others.

<i class="coffeecup-icons-arrow-<?php echo($sortWADAproducts_1->activeSort("CategoryName")=="DESC"?"up":"down"); ?>">

thanks Ray, really appreciate it

couple of questions.

1. apart from the product_results file, what other files do I need to get?
2. how would I clear them when the visitor navigates to another page
3. how would I clear one when another one is clicked?

You need to get the rsobj.php file.

I had to make a few more adjustments to make it work the way you wanted. I've done those. Please don't open and apply the sort server behavior until the next data bridge update, because it will break the trigger so that you can't clear the sort.

To clear the sort, just link into the page with ?sort= in the url with a blank sort value.

many many thanks :)