I have this on my db. mysql> select * from rates_dhl where weight_kg = "6" between range and Weight_KG; +----+-------+-----------+--------+--------+--------+--------+--------+--------+--------+--------+ | id | range | Weight_KG | Zone_A | Zone_B | Zone_C | Zone_D | Zone_E | Zone_F | Zone_G | Zone_H | +----+-------+-----------+--------+--------+--------+--------+--------+--------+--------+--------+ | 1 | .000 | .5 | 9.45 | 12.29 | 14.18 | 15.12 | 16.59 | 18.48 | 21.32 | 23.63 | +----+-------+-----------+--------+--------+--------+--------+--------+--------+--------+--------+ 1 row in set (0.00 sec) When i did try the between, even when i try to change the weight_kg to any number, it only display the first entry. On Fri, 5 Nov 2004 15:52:16 +1000, Murray @ PlanetThoughtful <lists@xxxxxxxxxxxxxxxxxxxx> wrote: > > > > > OK, here is what it should do. > > > > I have a fixed range of weights from .5 to 20.0 Kg (kilogram) and for > > each weight it has a succeeding value, i cannot jump or just round off > > the numbers. So i need a range detector to do it. > > > > Because for each of the item below: > > > > > weight value > > > .5 9.45 > > > 1.0 10.71 > > > 1.5 11.97 > > > 2.0 13.23 > > > > I must get the exact value, so let say for example. I have 1.3 it > > should fall under 1.5 the idea i had was to do this, so i can detect > > where the number should fall.. > > Put the weight ranges in a MySQL table and use the BETWEEN operator to > retrieve the appropriate weight. > > Something like: > > fromweight, toweight, value > 0,0.5,9.45 > 0.501,1.0,10.71 > 1.001,1.5,11.97 > > Then, the following SQL statement will pull the appropriate value: > > SELECT value FROM weights WHERE 1.3 BETWEEN fromweight AND toweight > > Much warmth, > > Murray > http://www.planetthoughtful.org > Building a thoughtful planet, > One quirky comment at a time. > > -- > > > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Louie Miranda http://www.axishift.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
