Help with selecting between a range of numbers

[baffled_in_UK]

Hi,

I have this table :
postage_value (dec 5,2)
weight1 (mediumint 5)
weight2 (mediumint 5)

I have 4 records :
5.99 : 0 : 100
6.99 : 101 : 200
7.99 : 201 : 300
8.99 : 301 : 99999

I have a select as follows :

$result = mysql_query("SELECT * FROM postage WHERE (weight1 >= $weight AND weight2 <= $weight ) ",$db);

the value of $weight is 36

I'm wanting it select record 1 (5.99) but it selects nothing?
Am I missing something ?

Thanks

[weevil]

Maybe I am confused, but if your data is listed in the same order as the columns of your table then your query should return nothing.

weight1 >= $weight AND weight2 <= $weight

0 >= 36 AND 100 <= 36 are both false

[baffled_in_UK]

Sorry

it should read

weight1 <= $weight AND weight2 <= $weight

0 <= 36 AND 100 <= 36

shouldn't that select the record ?

[weevil]

Actually, no
100 is still not less than or equal to 36
this will select only the first row

weight1 <= $weight AND weight2 >= $weight

[baffled_in_UK]

Is there anyway around this ? It's doing my head in :rolleyes:

[weevil]

Now I know I am confused. Is there any way around what?

[baffled_in_UK]

As my original post says... I need to to be able to select a row where a value I specify exists bewtween two values in the table

[weevil]

this will select only the first row

PHP:

weight1 <= $weight AND weight2 >= $weight

---

This will return the first row when $weight is between 0 and 100, the 2nd row when $weight is between 101 and 200, and so on. I am not sure what else you want.