Sort Products By Price

Started by Rochdalemark, Feb 27 2006, 16:12

You cannot reply to this topic
Go to first unread post

2 replies to this topic

#1 Rochdalemark

Community Member
468 posts

Real Name:Fred Doherty
Gender:Male
Location:Rochdale U.K

@Mention

Posted 27 February 2006, 16:12

I have my products listed in colums, and at the moment they are listed by product name. ie:-

125Kg Traditional Sack Truck | 150Kg Folding Toe Sack Truck
150Kg Solid Toe Sack Truck | 200Kg Folding Toe Sack Truck

etc

But when I go into index.php and change the following:-

if ($column_list[$i] == 'PRODUCT_LIST_NAME') {
		  $HTTP_GET_VARS['sort'] = $i+1 . 'a';
		  $listing_sql .= " order by pd.products_name";
		  break;

To

if ($column_list[$i] == 'PRODUCT_LIST_NAME') {
		  $HTTP_GET_VARS['sort'] = $i+1 . 'a';
		  $listing_sql .= " order by p.products_price";
		  break;

My listings get messed up. It's fine on the first page but as soon as you click through the pages 1,2,3 etc the same items keep cropping up on different pages as though there listed at random.

Can anyone help with this? I'd really like to keep everything ordered by price.

Thanks in advance for any help.