Dropdown boxes if......

MBK

Hi All,

I have a form that has 4 dropdown boxes on it, the value in the 2nd box depends on the value selected in the 1st box, and so on.

How do I write a script so that this will work.

i.e if box1 = a, then box2=1, or if box1=b then box2=2 etc.

Can anyone help me on this please?
I know I can do it using submit, but that will be too long for the user.

Pls help!! 🙂

stuartc1

If you want to avoid reloading the page then it sounds like a job for JavaScript.

Do you want all the drop down boxes to have mulitple options (like 10 option in each box or something) ?

MBK

each box will contain different options.

My db has 5 columns, and approx 300 entries.
several of the entries are similar and I need to get my end result defined exactly right.

I need it so that when the user selects the first drop down box, a query is ran on my db and the results populate the second drop down box - from here there may be an optional dropdown box or it will ouput info from a further query on my db.

Hope that makes sense.

User Selects from box1-
(DB Query - Results populate box2)
User Selects from box2 -
(DB Query - Results are either displayed or another query ran)

Pls advise if u know any way of doing this!

stuartc1

OK, I get it.

here is what to do:

Create Javascript so that when an option is selected the page will pass information into the query.
Run the Query based on the value passed (from the drop-down), return the values for the next drop-down (if applicable), also pass back the value from the first drop-down so that value can be pre-selected.
do the above untill you reach the end.

Please reply if you have any poroblems understanding this, or would like the syntax for any of it.

MBK

I understand what u are saying, and I had planned it out that it would need to be done it that way.

However, I know very little Javascript, and have basic knowledge of db queries, I can query the db and get results, problems would arise when I have to store the results and then populate the boxes.

That said, any help you could give with the code/syntax would be a great help!

Thanks.

🙂 🙂

stuartc1

OK Query/Drop-Down first:

$db = mysql_connect("localhost", "root"); // database connection
mysql_select_db("mydbname"); // select the database

$sql = "SELECT whatever FROM whatever WHERE whatever=whatever"; // SQL code

$qry = mysql_query($sql, $db); // query

echo "<select name=\"myselect\">";
while ($res = mysql_fetch_array($qry)) {

// create variables from the results
$field1 = $res["field1"];
$field2 = $res["field2"];
.. and so on

// complete the drop-down

echo "<option value=\"id=$field1\">$field1"; // this will loop the results

}

echo "</select>" // end of the drop-down

OK so when this gets submitted the it will pass the variable $myselect with the value of the select. Use this to run the second query.

Anyway, I need to get on with some work now, I will post more code tomorrow (javascript etc)

HTH.

MBK

helps a lot,
thanks - look forward to the javascript.

MBK

jnuneznyc

Look for one of my post within the last 3 days. It has a function to create drop downs and you pass it a SQL Query.

The javascript event required to post is onChange=""

Get the db2select function and let me know if you have that working then I will post the onChange as it will vary for each of the four dropmenus

UPDATE: HERE IS THE LINK TO MY FUNCTION db2select()

MBK

stuartc,
Any chance of that help on the Javascript?? or anyone!

Know v.little re Java script, and that is the only bit I need...

jnuneznyc

ok here is some of it...
Each Drop box will have the following code on the <SELECT> tag

onchange="formname.submit()"

As soon as you make a change it will submit the form. Then in your php code you can use db2submit and make that value default for the dropdown and then search for all the items for the following drop down. If you post some of your code I could help you some more.

MrAlaska

This page does something like what you are talking about using javascript, except with list boxes instead of dropdowns but it is pretty much the same:
http://www.csd.toshiba.com/cgi-bin/tais/su/su_sc_modSel.jsp

If you check the source, you will see that ALL the records need to be loaded on the client, then javascript determines what to display based on the selected item.

To do it with PHP, you would need to pass the selection from page to page.

tjbarr

Did you figure this out?

bobby_rahman

Hiya I hace created a dynamic table and have entered a drop down box. I wish to get all the column titles from the table and be able to order the table depending on the selected filter automatically ( in a perfect world with out refreshing)

I can get all the fields into the drop down box on the form but now need to build in the logic of sorting tha table depending on the choice.

Im sure it will contain the logic of
SELECT * from <table name>
......
ORDER BY $filter

//the $filter = selected from the drop down

I need further suggestions on
1. Where I can find a decent tutorial on dynamic drop down boxes(if they called that in the first place)
OR/AND
2. Code snippets that may help me to understand the logic

Any help wld be great Thanx 🙂