PHP MySQL problem with negative numbers using the expr between

[SundanceKid]

Hi everyone,

I am having a problem with a between expression. When I use positive numbers I get everything ok. When I search for Negative numbers I get nothing.

$StartVal = ((($a_s_word .05) - $a_s_word) -1);
$EndVal = (($a_s_word * .05) + $a_s_word);

WHERE ($a_s_item between $StartVal and $EndVal)

Please Help.

Input Range

Positive Number
Selection: Diameter +/-5% Range: 22.8 to 25.2 Selected: 24

Negative Number
Selection: Effective Focal +/- 5% Range -117.8 to -130.2 Selected: -124

[YappyDog]

Normally with a between statement your two values that make up your range are listed with the smaller number first. The between statement is the equivalent of saying >= first value and <= second value.

So, if your first value is greater than your second value it might not work.

$StartVal = -117.8;
$EndVal = -130.2;
WHERE ($a_s_item between $StartVal and $EndVal)

might need to be
WHERE ($a_s_item between $EndVal and $StartVal)

[SundanceKid]

Thanks Yappy dog you were correct.. Logic it was in front of my face the whole time.