How to change product listing to 'Price Order'

[Mcshandy75]

Hi all, I am currently wanting to sort my product listings by price order. Have changed the index.php to:

 

 

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_PRICE') {

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

$listing_sql .= " order by p.sort_order, final_price";

break;

}

}

} else {

$sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);

$sort_order = substr($HTTP_GET_VARS['sort'], 1);

$listing_sql .= ' order by p.sort_order';

switch ($column_list[$sort_col-1]) {

case 'PRODUCT_LIST_MODEL':

$listing_sql .= ", p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", products_name";

break;

case 'PRODUCT_LIST_NAME':

$listing_sql .= ", products_name " . ($sort_order == 'd' ? 'desc' : '');

break;

case 'PRODUCT_LIST_MANUFACTURER':

$listing_sql .= ", m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", products_name";

break;

case 'PRODUCT_LIST_QUANTITY':

$listing_sql .= ", p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", products_name";

break;

case 'PRODUCT_LIST_IMAGE':

$listing_sql .= ", products_name";

break;

case 'PRODUCT_LIST_WEIGHT':

$listing_sql .= ", p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", products_name";

break;

case 'PRODUCT_LIST_PRICE':

$listing_sql .= ", final_price " . ($sort_order == 'd' ? 'desc' : '') . ", products_name";

break;

}

 

 

Can anyone help and tell me where I might be going wrong?

 

Thanks in advance!