Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

listing products in price order


millhouse

Recommended Posts

Think this should be an easy one.

 

I'm trying to list the products by price order instead of alphabetically as they are currently.

 

Any advice?

 

Also i have installed a live helpler feature recently. I have a security cert but am getting the 'this page contains both secure and non-secure items' message.How can i secure this feature.

 

thanks all

Link to comment
Share on other sites

Think this should be an easy one.

 

I'm trying to list the products by price order instead of alphabetically as they are currently.

 

Any advice?

 

Also i have installed a live helpler feature recently.  I have a security cert but am getting the 'this page contains both secure and non-secure items' message.How can i secure this feature.

 

thanks all

 

 

 

 

I'm still struggling with this one if anyone has any thoughts.

 

thanks

Link to comment
Share on other sites

on index.php look for

 

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

 

and change that to

 

$listing_sql .= " order by p.products_price";

 

 

That will take care of it on the product listing part of the pages where it shows all products in a catagory.

 

There are other pages such as products_new.php that will also need to be edited. If you open them in an editer just search for "order by" and change how it is being ordered to the order by p.products_price

Wendy James

 

Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...