[RESOLVED] Getting the nearest results from a few of options.

[foxroberts]

Hi.

I want to build a match program with multiple options.
I wonder how the db-query has to look like:

The user for example searches for:
Option A = 6, Option B = 2, Option C = 5, Option D = 5

The results should look like this:
A = 6, B = 3, C = 5, D = 5
A = 5, B = 2, C = 4, D = 4
A = 7, B = 2, C = 4, D = 6
and so on.

Is there a way not to look for all the single options,
but to order the entries by the smallest difference
in all categories?

Thank you for any hint.

Fox

[tomhath]

It should look something like this:

select A,B,C,D from theTable
order by (abs(A-6) + abs(B-2) + abs(C-5) + abs(D-5) ) 

or

select A,B,C,D from theTable
order by sqrt( (A-6)*(A-6) + (B-2)*(B-2) + (C-5)*C-5) + (D-5)*(D-5)  )