how to pass the value of a selected option ?

[Anon]

i have created this drop down box
that lists different groups, how do i pass the value of the selected option to another page so i can display the results of a search ? i looked at other examples here and did not find one that covered this issue directly.

code:

$query = "SELECT DISTINCT bgroup from employees order by bgroup";

$result = mysql_query($query);

/drop-down list/
while(list($bgroup) = mysql_fetch_row($result)) {
print "<option value=>$bgroup</option>\n";

[Anon]

ok.. first at all.. you should name the select statement

i.e.

<select name="groups">
//here goes your script with the options
</select>

and the options should have a value

i.e. <option value="1">1 </option>

so in your code it would something like

while(list($bgroup) = mysql_fetch_row($result)) {
print "<option value='$bgroup'>$bgroup</option>\n";

note the value= '$bgroup'

this value is the one you'll get on your next page, in your next page you should just print out $groups, "echo $groups", remember it's the options' name.

i hope this helps

[Anon]

Hi,

How about multiple selections? I looked into virtually all the books in Border about php and html; there was only one book mentioning how the multiple selection in a dropdown list is returned to the server - by pairs of name/value but there was no example.

Could someone please help me show me how to implement pairs of name/value returned by multiple selections? Do you use an array to receive pairs or there are other ways?

Here is a simplified code:

<select name="selectedPlans" multiple size=3>
<option value="PlanA" > Plan A
<option value="PlanB" > Plan B
<option value="PlanC" > Plan C
<option value="PlanD" > Plan D
</select>

Assume PlanA and PlanC are selected by the user at client. What kind of php code at server is needed to deteced all the selected choices and to further process them.

Thanks in advance.

Kayaker

[Anon]

Make your name an array:

<select name="selectedPlans[]" multiple size=3>

Now you can receive the results as selectPlans[0], [1], etc.

[Anon]

thanks Frewuill, this has helped.

i have another question now, it seem that the info being passed is on the firt word of the group, how do i get it to pass a 2 word phrase ?

example:

"group one"
is passed as just
"group"

[Anon]

OK I though that the problem is due you are using list which is a list constructor this cause i.e. if you have the value $value= " group one" and use list($value), it would construct the list ("group","one") .. =) then when you use $value it takes the first value, i would bet that if you use $value[1] you would get "one".
What i would recommend you is use just

while($bgroup = mysql_fetch_row($result)) {
print "<option value=>$bgroup</option>\n";

instead of

while(list($bgroup) = mysql_fetch_row($result)) {
print "<option value=>$bgroup</option>\n";

That would help.

[Anon]

thanks Frewuill

actually i figured it out, it is really simple i just put the value in quotes
like this:
while($bgroup = mysql_fetch_row($result)) {
print"<option value='$bgroup'>$bgroup</option>\n";

and it will pass the complete phrase.

Thank you Frewuill, you helped me out when all the world was against me(or so it seemed)! ... 🙂

[Anon]

Kirk,

Thanks. It works.

Kayaker