Hi All,

I'm certainly no mySQL guru so i'm looking for some assistance with a query. The query below brings back 1 exact match fine but the data in the table is not fully complete. What I want to do is return the all results in order of 'all 5 match', '4 match', '3 match', '2 match', '1 match'.

SELECT * FROM master WHERE
make_id=$make AND
model_id=$model AND
variant_id=$variant AND
engine_id=$engine AND
issueyear_id=$issueyear
LIMIT 1"

I hope I've explained it ok! Any help would be appreciated. Thx in advance.

Pete