Hello, DBmasters. Me again trying to do something I probably shouldn't again.
Anyway, one of my databases has three zip code fields. $low, $high, $theZip.
I am trying to make sub query() return records that are between 2 zip codes, defined by $low and $high. The zip code to be tested is the third field, defined only for searching. I have a conditional that I can use to test the value of $theZip, but I am stumped as to how I can incorporate it into sub query. Has anyone successfully implemented a dual range check before?
Anyway, one of my databases has three zip code fields. $low, $high, $theZip.
I am trying to make sub query() return records that are between 2 zip codes, defined by $low and $high. The zip code to be tested is the third field, defined only for searching. I have a conditional that I can use to test the value of $theZip, but I am stumped as to how I can incorporate it into sub query. Has anyone successfully implemented a dual range check before?