Getting the input from your form.

[kwok]

Hi!

Wonder if anyone there can point me to a direction. In a dropdown selection list within a form, I am trying to pass the selected item to a "where" clause in a select statement, but I can't get the value from the dropdown selection list. I have try sending the select variable through the HTTP_POST_VARS['myselect'], but the variable is empty.

In the <form> tag I use something like this:
<option value="Phone" name="myselect">phone
<option value="address" name="myselect">address
.........

and
within the <?php> tag I have statement like:
$myselect=HTTP_POST_VARS['myselect'];
select fields.... from table where $myselect .....

If I can get the variable value from the form, worse case I can hard code the select statement using a case loop. Thanks in advance.

[markl999]

Firstly it would be $HTTP_POST_VARS, not HTTP_POST_VARS, and secondly, if you're using PHP >= 4.1.0 then you should really use $_POST['myselect'] instead

[Caldus]

<?php

...

$sql = "SELECT * FROM table WHERE field = {$_POST['myselect']}";

...

?>