How to setup a range variable properly.

sgtpepper

I would like to have a varible in a form that allows a user to select a range of numbers. For example

<input type="radio" CHECKED value="0" name="units">Any number<br>
          <input type="radio" value="1" name="units" 5<br>
          <input type="radio" value="2" name="units">5 to 10<br>
          <input type="radio" value="3" name="units">11 to 15<br>
          <input type="radio" value="4" name="units">16 to 20<br>
          <input type="radio" value="5" name="units">21+</font>

Notice I am trying to give them the ability to select 5, or between 5 to 10, etc....

My problem is I am not sure how to setup the value correctly, or how to setup my query. I thought BETWEEN would be the right approach, but I am not having any luck.

AND nof_units between '$units' AND 'NOT SURE WHAT GOES HERE'

Can you offer a suggestion?

bad76

Hi,
if you have to skip from 5 to 5 just can try this:

AND nof_units between '$units' AND '".$units+5."'

But i think better to make a convertion array:

$conv[]="AND nof_units<5";
$conv[]="AND nof_units between 5 AND 10";
$conv[]=...

it's more "changeable" (can't think the exact term...)...

see you

sgtpepper

The convertion array looks like the right approach. Could you give me a few more specifics on how to code this? I am still learning php...

For example where does $conv come into play?

bad76

You can just
add it to query string.

the receiver php script:

<?
$conv[1]="AND nof_units<5"; 
$conv[]="AND nof_units between 5 AND 10"; 
$conv[]=... 
...
// do other stuff
...
$myquery="select blabla from mytable where bla bla".$conv[$units];

$res=mysql_query($myquery) or die(mysql_error()."<br>".$myquery);

....
//do other stuff
?>

I hope this help you