<select> statement how to get information out

[iron999mike]

OK. this should be really simple, but it hasn't been. I am posting all this data to the same page (probably should use php_self). When I try to get the variables from the dropdown lists, it acts like there not there (all of the other input types in the form i can use)

<form action="lada.php" method="GET">

Price order:

<INPUT type="radio" name="price_order"
value="lowtohigh"> Price (low to high)
<INPUT type="radio" name="price_order"
value="hightolow" checked> Price (high to low)
</br>
</br>
Order By Category:
<INPUT type="radio" name="cat"
value="y" checked> YES

<INPUT type="radio" name="cat"
value="NULL"> NO
</br>
</br>
<select name="price_below" size="1">
<option value="NULL"> Price is Below...
<option value="10.00">$10.00
<option value="20.00">$20.00
<option value="30.00">$30.00
<option value="40.00">$40.00
<option value="50.00">$50.00
<option value="60.00">$60.00
<option value="70.00">$70.00
<option value="80.00">$80.00
<option value="90.00">$90.00
<option value="100.00">$100.00
<option value="150.00">$150.00
<option value="200.00">$200.00
<option value="300.00">$300.00
<option value="400.00">$400.00
<option value="500.00">$500.00
<option value="1000.00">$1000.00
<option value="2000.00">$2000.00
<option value="5000.00">$5000.00
<option value="10000.00">$10000.00
<option value="50000.00">$50000.00
<option value="1000000.00">$1000000.00
</select>

.....Other forms w/ same problem......

</br></br>
<input type="hidden" name="orderby" value="Set">
<input type="submit"> <input type="reset">
</form>

I can call $price_order and get the value.
When I call $price_below I get nothing.
I have tried using get & post.

Using get gives the url:
http://www.lada.php?price_order=hightolow&cat=y&price_below=80.00&price_low=NULL&price_high=NULL&orderby=Set

I can say:
<?php>
printf("This one works and prints out the value: %s", $cat);
printf("This one doesn't: %s", $price_below);

As you can see when I click on a price it sets price_below and passes it, but when I call it, it gives nothing.

Any ideas?

[BuzzLY]

rename your select so that it has [] at the end:

<select name="price_below[]" size="1">

On the posted page, you access the field as if it were an array (because it is).

A couple of observations:

1. Use POST instead of GET. There really is no reason to use GET when you are posting data from a form to another page.

2. Turn off register_globals and use $_POST['variable_name'] to access your variables. This allows for portability and will prevent your apps from breaking when you upgrade PHP.

[iron999mike]

Thanks.

I can print the the array with print_r($)

One other question
Do you know how to query a MySQL database
with the array?

And no I haven't changed to POST yet or used $_POST["price_below[]"] yet. I will when I can get this up and running.

elseif ($cat == 'y' && $price_low == "NULL"
&& $price_high == "NULL" && $price_below != "NULL"
&& $price_order == "lowtohigh") {
$sql = "select * from wishlist, Description, Category,
location WHERE wishlist.desc_id = Description.desc_id &&
Description.cat_id = Category.cat_id &&
Description.loc_id = location.loc_id
&& 'price' <= '$price_below[]'
order by 'category', 'price'";
}

[BuzzLY]

remember that $price_below is now an array. If you only have one value, then refer to it as $price_below[0]. If you have multiple values, then you will need to iterate through the array with for() or foreach().

HTH

[iron999mike]

Yes, I tried that with the (with the [0] at the end.) I must have the wrong format for putting it into the query.