select similar values from mysql database
I have several data s in MySQL database. In my table there is a column called rank. what I want is when some one enter a rank say 25 then the result should display names on similar(+ or -) ranks LIMIT to 10 from table.

example 

mathew - 25<br>
john - 26<br>
joe - 25<br>
stewart - 27<br>
kelly - 24<br>
brandon -23<br>
magy - 22 .......etc.<br>

Thanks
Mathew


  
select similar values from mysql database
===

I have several data s in MySQL database. In my table there is a column called rank. what I want is when some one enter a rank say 25 then the result should display names on similar(+ or -) ranks LIMIT to 10 from table.

example 

mathew - 25<br>
john - 26<br>
joe - 25<br>
stewart - 27<br>
kelly - 24<br>
brandon -23<br>
magy - 22 .......etc.<br>

Thanks
Mathew


  