Numeric Range Problems

ywickham

I'm running a query that selects records from within a range, for instance, if the number was 2.16, it would fall within the 1.901 to 2.9 range.

Unfortunately, this is not what is happening. Can someone tell me why, and how maybe I can work around it?

Here is my code:

/values from database would be: resolution_1_width = 1800, resolution_1_height = 1200 /

$digipage = 2;
$range = 0.099;
$end_range = 0.9;

$query = "SELECT camera_id, resolution_1_width, resolution_1_height
.
.
.
WHERE ((resolution_1_width * resolution_1_height)/1000000) BETWEEN $digipage - $range AND $digipage + $end_range";

Thanks for any help!

gid

might want try using more parents like this:

WHERE ((resolution_1_width * resolution_1_height)/1000000) BETWEEN ($digipage - $range) AND ($digipage + $end_range) I've never used BETWEEN before, but that should work....

Also, make sure the the first range is less than the second:
expr BETWEEN min AND max

ywickham

Thanks Steve, but the parenthesis didn't make a difference.

Any other ideas, anyone?

zmola

maybe this will help?

http://www.bitmechanic.com/mail-archives/mysql/Apr1997/0128.html

ywickham

Thank you zmola. That was a great, informative thread (something I knew, but had long since forgotten.) 🙂

I actually figured out why my entry was not appearing. It had nothing to do with how my clause was constructed, but in that one of the data entry people forgot to fill in a field I expected to be filled.

I suppose I will have to write in a function to track missing expected fields as well.

Thanks everyone!