display result based on relevance

[clydelo]

Hi here's my problem.

I making a query based on 4 criterias the user must enter : criteria A,B,C and D.

Now when displaying the result,I want the results that match all the 4 criterias on top and then all the results that match 3 criterias and so on..

Can anyone help me out? How can I arrange the positioning of my results?

Thx

[stuartc1]

You could create a function that reads through each result counting the critea results, add them to an array and sort by count.
:->

[Anon]

Thx. ScottishDude for replying..

But i'm still confused.. could you be a bit more explicit..

An example would be most welcome..