Re: selecting the 'best' match

2009-05-12 Thread blackwater dev
g 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, bla

selecting the 'best' match

2009-05-12 Thread 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 at the

load data infile

2005-06-30 Thread blackwater dev
Hello all, I have a file where the data looks like this: "1","23","345","45"; "34","4","444","1er"; I am then trying to load that data using the load data local infile and this statement: Load data local infile '/httpd/htdocs/sql/loader.sql' into table vehicles fields terminated by ',' enclosed