Thanks but doing it in code would require me to pull in the entire car table
and process it. With potentially tons of rows, seems like I should be able
to use the db to get those.
On Tue, May 12, 2009 at 12:23 PM, Johan De Meersman <vegivamp@stripped>wrote:
> 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
>> 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
>> 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
>> 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.