Sorting on multiple price fields
Posted: Mon Jun 06, 2011 2:24 pm
I'm trying to make a kind of "vacation rental" listings site and I've been asked to make it handle multiple price values:
Price per night
Price per week
Price per month
Just adding those 3 fields is easy of course but where it gets complicated is it has to be able to sort the search results by price.
I've been looking for examples of this on other sites and I've found this one
http://www.homeaway.com/search/caribbea ... n:9/page:2 (you may need to do another search manually and sort it by price)
It claims to allow sorting by price but when I do that initially it seems to sort them but as you look through there are a number of items that seem out of place based on their price.
How do you think this site is sorting it's results?
The other complication is the possibility of going with a mix price ranges along with single price fields.
For example
$100 - $200 per night
$600 - $850 per week
$3000 per mont
How should I approach sorting my results?
Price per night
Price per week
Price per month
Just adding those 3 fields is easy of course but where it gets complicated is it has to be able to sort the search results by price.
I've been looking for examples of this on other sites and I've found this one
http://www.homeaway.com/search/caribbea ... n:9/page:2 (you may need to do another search manually and sort it by price)
It claims to allow sorting by price but when I do that initially it seems to sort them but as you look through there are a number of items that seem out of place based on their price.
How do you think this site is sorting it's results?
The other complication is the possibility of going with a mix price ranges along with single price fields.
For example
$100 - $200 per night
$600 - $850 per week
$3000 per mont
How should I approach sorting my results?