multiple selection listboxes

[tjbarr]

Since the listbox below is a multiple select box will it store the answers in an array as the code is written below or does it need to be modified. If this will store the selections in an array, how can I echo an element of the display.

Please choose the Variables you want for Source - U.S. Bureau of Labor Statistics:<br>
<select name="cbovarbls" size="auto" multiple class="listbox">
<?php

/
Create your SQL statement
/

$sql="SELECT var_no, var_name from tbl_ei_var WHERE (ei_id=$ind_ch) AND (srce_id=111);";
$result_set = pg_Exec ($conn, $sql);
$rows = pg_NumRows($result_set);

if ((!$result_set) || ($rows < 1)) {
//No connection or no rows returned, so print an error
echo "<H1>ERROR - no rows returned</H1><P>";
exit; //exit the script
}

for ($j=0; $j < $rows; $j++) {
echo "<option value=".pg_result($result_set, $j, "var_no")."> ".pg_result($result_set, $j, "var_name")."</option>";
} } }

?>
</select>

[archangel_617b]

On the page where you post this form to, you can print your form inputs. Your code should just make $_POST['cbovarbls'] (assuming your form is method=post).

To view that variable (gives you a better idea of how to handle it):

print('<pre>');
print_r($_POST);    // will display all submitted values
print('</pre>');

If it shows up as a normal array, you can usually do something like this to read it:

for($i = 0; $i < count($_POST['cbovarbls']); $i++)
{
    print($_POST['cbovarbls'][$i].' is the value of the '.$i.'th element.<br />');
    // or whatever it is you want from the data
}

I hope I have helped answer your question.

[swjohnson]

is using the each() and list() commands in the following manner...

each(arrayname)
list(val1,val2,val3,etc.)

Here is an example...

For the first record you have

$http_get_vars["fname"] // and its value is "joe"

$http_get_vars["lname"} // and its value is "smith"

each(yourarray)
while (list($key, $val) = $http_get_vars)) {
echo $key has a value of $value".<br>;

This will produce:

fname has a value of joe.
lname has a value of smith.

[archangel_617b]

[man]print_r/man is your daddy and using $_GET instead of the old $HTTP_GET_VARS is a good idea.