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

guido2004
—
2011-05-18T12:54:16Z —
#2

To get all results, get rid of the LIMIT

To order them based on the number of matching columns is a bit trickier I think. No time to think about it now, maybe someone else knows the solution?

appy
—
2011-05-18T17:26:38Z —
#3

Thanks for the advice, I've gone down the multiple queries and PHP route for know but will look around to see if i can get it down to the 1 query.