sort by price help

[brendanmc25]

hi all,

 

I have been asked by a friend to change something on the oscommerce site I did for him over a year ago now. He wants to enable the sorting of his products by price.

 

I have tried the few solutions on the web but to no avail. The following doesn't change the ordering when i edit the index.php file.

 

if ($column_list[$i] == 'PRODUCT_LIST_PRICE') {

$HTTP_GET_VARS['sort'] = $i+1 . 'a';

$listing_sql .= " order by final_price";

 

I can't get any change in the ordering whatsoever. Could the reason why the above code doesn't work have anything to do with having a mod in my site - the product listing mod where the products appear in boxes with thumbnails? Can anyone suggest something to try please?

 

As I say, I completed this site over a year ago and haven't looked at php since!

 

Regards

 

Brendan