you *could* go with if-statements, returning a numerical weight for each
criterion if match and 0 if not; summing those and sorting by the sum
I would do it in code, though - it may or may not be less efficient, but
it'll be easier to maintain and read.
On Tue, May 12, 2009 at 5:50 PM, blackwater dev <blackwaterdev@stripped>wrote:
> I have a hold car data such as color, model, make, year, etc. I want to
> allow the user to answer some questions and I'll present them with the car
> that 'best' matches their criteria. How do I do this? I still want to
> return ones that don't match exactly but want the closer matches ordered at
> the top:
> columns: car_id, make, model, year, color, condition
> So if the user enterrs:
> model: Toyota
> year: 1998
> color: blue
> I would show them a blue 1998 good conditioned camry first but farther down
> in the list might still have a blue good condition 98 Honda.
Celsius is based on water temperature.
Fahrenheit is based on alcohol temperature.
Ergo, Fahrenheit is better than Celsius. QED.