Sorting Mysql Results by # of found keywords?

[Ajm113]

Hello everyone. Ok this is my goal:

When a user sorts by number of keywords and lets say one result had 5 keywords of what the user entered in that has a better chance on being up top. I already know how to find keywords in a string of a result, but how can I tell php or mysql where it should be if it had a lot of keywords or not a lot?

Thanks, Andrew.

[MarkoKlacar]

Hi Andrew,

I'm not quite sure I understand your problem, I understand you want to sort something in a particular order depending on the number of matched keywords.

Could you perhaps post some code or give us a better look at you situation.

Cheers