Text if a record falls between two numbers
I'm trying to write a script that takes a variable (passes as a script parameter) we'll call this $number. I then want to compare it to $low and $high. If $number is not between these two I want to omit the record and only be left records where $number is between $low and $high. I am trying:
if($low < $number AND $number < $high)
Go to next record
Is this the proper way or am I missing something? Either way, it is not working.
Any help is greatly appreciated.