$A = between $B and $C

LordRogaine

I have a form in which a user can pick the age of people. I have two scroll bars with ages. "$Scroll bar 1" would have the values of 18 and up to 100. "$scroll bar 2" would have the values of 100 down to 18. How can I get $Age to = what is between these two fields? In other words I want $A = what is between $B and $C. Any ideas on this? Thanks.

cgraz

What exactly is a scroll bar? Are you referring to a drop down?

Not sure I'm understanding you correctly as this seems like a simple subraction problem, but you want variable a to equal the difference between b and c?

$a = $c - $b;

if c is bigger, do it that way. If b is bigger,

$a = $b - c;

Cgraz

LordRogaine

I think I need to rephrase this a little. I'm not looking for the difference between $B and $C. Let's say $B=20 and $C=25.
I want $A to pull all the values from a table that = 20 or 21 or 22 or 23 or 24 or 25

example: "select * from table where $A between $B and $C";

Does that make sense? I'm probably not explaining this too clearly.

LordRogaine

lol nevermind on this one. I got it to work. Thanks

cgraz

Ahh, I see what you wanted to do. Yes BETWEEN() is the best way to go.

Cgraz

LordRogaine

did you get my lat post where I posted the form I was using for check boxes?