[RESOLVED] search on range of heights not working

visit

and search is not working properly give height range as

5 to 5.5
following query is executed

SELECT * FROM data1 WHERE ( height >=5 and height <= 5.5) order by surname, firstname

which I feel is correct

however the reult is not correct

I found following entry erroneous

G01457 Nevalkar Mihir 32930621/ 9323211402 example@example.com
Groom 27 Yrs.
1981-11-19 5.11 Gautam

Before concluding pls let me tell you that data was originally in excel sheet
and height was specified as

5'05"
6'01"
5'11"
5'10"
5'08"
5'11"
5'10"
5'04"
5'11"
5'06"

I derived height as follow : (height is stored in data[21] )

list($ft, $in) = split('[\"\']',$data[21]);
$height= $ft+($in/100) ;

and filed is defined as
height decimal(10,2) Yes NULL

please help me to reolve this

Well, you've got two things wrong:

Don't know why you think that's wrong; 5.11 is less than 5.5 and obviously greater than 5.0, so it should appear in the results.
Your formula to convert the formatted height (e.g. 5'11") into a decimal is incorrect. You have $ft+($in/100), but that implies that there is one hundred inches per one foot.