Word Density analyser

[joe2]

Hi,

1 __a,b c,a,a b,d

2___b,a,b,b a,d

3___c,a b,c,c,d,a

in above table row 1 has maximum density of "a" and row 2 has maximum density of "b" and row 3 has maximum density of "c".if some body searches for the word "c" .All the three row will display.But "c" should come on top.Because it has got maximum density.Please suggest some idea how to do it.

I am using php/MySQL and LIKE statement of sql.

Thanks in advance.

[hkucsis]

basically you should take out from the DB what the user wants to search (use SQL -- like %c%), then with the selected rows, you can use substr_count to sort them according to the density.

[joe2]

Thanks for the immedaite help.I will try the mentioned function.

Thanks