multiple drop down boxs

Anon

can anyone plz help with a coding problem i have with php/mysql. I have a db table from where i am pulling some values into an select/option box. Using that i can pull across 2 values only & i want to be able to pull across 3 values..

the data in the table for each record is as follows :

id
title
sectionid

i display on the page the value from the title field & the id is hidden from view :

<option value=$id>$title</option>

what i want also capture somewhere is the sectionid value either hidden or displayed on the page in the form of another dropdown that changes depending on what is selected in the above select box.

Can anyone give some pointers plz.

Thanks

Kass

amcgrath

Well, you could make the value=$id[$sectionid], or $id-$secitonid and explode it on the "-", there are a couple ways to do what you want....

Anon

Looking at the problem outside of the context, I'm a little confused what you are trying to accomplish.

<option value=$id>$title</option>

This only passes the $id value. You will have to use $id to pull $sectionid and $title to place in another table upon post.

If you need to pass all the values then going Allen's route might be your choice.

<option value=\"$id-$title-$sectionid\">$title</option>

I don't know what having another drop down would accomplish since you have the $sectionid assigned to $id.

Ron

Anon

Thanks for the replies

tho i am also showing the $title value, i will not be inserting that into the table. I will only be inserting the $id & $sectionid values.

Kassim

Anon

the $id & $sectionid have to be inserted into two seperate fields. by joining them together under the same select name, will that not put the same values in both the fields once inserted into the table ?

Kassim

Anon

Someone just asked a similar question earlier this week. I think the solution that you are looking for requires java script. There is a tutorial on the Zend web site on this exact type of thing (if I understand what you're looking for).

http://www.zend.com/zend/tut/drop-down.php

The tutorial may be a little more "feature-rich" than what you were looking for.

Anon

Thanks DLB, i will have a look at it

mnuzum

I think that Allen's Solution would be best.

If what you have is two pieces of info that need to be sent to the server again, it may not be necessary for you to have two form fields.

Say you have only one option in the drop down list. The values you want to send are like this:
id = 20
sectionid = 5
title = swiss cheese

Your drop down list could look like this:
<option value="20|5">swiss cheese</option>

Then when your PHP script get's the value, it will see only 20|5. It then splits it like this:
list($id, $sectionid) = explode("|", $FORM_VAR);

Using JavaScript would work. I use it on my site but that's for when you have sub choices. For example, select list 1 displays a list of ids, select list 2 changes to show only the sectionids that are valid for a given id.

Hope this helps,
Matt

amcgrath

To repeat myself: "explode it on the "-", " then you have your 2 values..... explode() is a php funciton.