How do i...... Sort by price!
Submitted by kevquinlan on Sun, 2006-01-29 22:24.Price Tapestry
How would i go about setting it up to sort by price?
Home
Purchase
Downloads
Manual
Support Forum
Hi,
This is straight forward, but care would need to be taken on a very large dataset. Look in search.php for the following line:
$sql .= " ORDER BY search_name";To sort product search results by price ascending, change this to:
$sql .= " ORDER BY price ASC";.. or by descending price:
$sql .= " ORDER BY price DESC";If you could let me know if this looks OK (I just tried it on WebPriceCheck.co.uk) i'll build this into the search script so that a user can choose the sort field (i.e. a link along the top to switch to sort by price ascending or descending). There are some "search engine friendliness" considerations alongside this sort of feature; so i'll have a sleep on that...!
Cheers,
David.