in your code, you can define ranges of say if the model year being
looked for is 2002, then present model years 2000 thru 2004.
--Curtis
blackwater dev wrote:
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 <vegiv...@tuxera.be>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
column.
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 <blackwater...@gmail.com>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:
Table:cars
columns: car_id, make, model, year, color, condition
So if the user enterrs:
model: Toyota
year: 1998
condition:great
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.
Thanks!
--
Celsius is based on water temperature.
Fahrenheit is based on alcohol temperature.
Ergo, Fahrenheit is better than Celsius. QED.