SORTING PROBLEM

[sisteligent]

Hi,

 

Can you help me please?

 

How to sort products by price descendently?

[Guest]

http://www.oscommerce.com/community/contri.../search,sorting

[sisteligent]

doesn`t work

[sisteligent]

fixed

 

// Look for this code in catalog/index.php at around line 193

 

if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

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

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

$listing_sql .= " order by pd.products_name";

break;

 

//Replace this above line $listing_sql .= " order by pd.products_name";

 

//With this line $listing_sql .= " order by final_price desc";