Dependant Drop Down Box

[JimS]

Ok, I am trying to populate two drop down boxes with the results of a query. I have the first one set up and working but I am stuck on how to pass the results of the first query as a constraint for the second as there is no submit and every example I can find on the web only shows how to pass via post/get into another page. :mad:

Here is what I have for code:


Below are the functions that display the results of the query in a table.

function dd_joblist($user_name)
{
    $result=mysql_query("SELECT DISTINCT job_name FROM oats_jobs_users_laborCode where user='$user_name' order by job_name;"); 
    if($result)
    {
        echo "<select name=\"job_select\" onchange=\"$job_select=reload(this.form)\"> <option default=\"default\" value=\"*\">Choose One</option>"; 
        while($row=mysql_fetch_row($result))
        { 
            echo "<option value=\"$row[0]\">$row[0]</option>";
        } 
            echo "</select>";
    }
    else
    {
        echo mysql_error($result);
    }
}
 
function dd_laborlist($user_name, $job_select)
{
    $result=mysql_query("SELECT DISTINCT labor_code FROM oats_jobs_users_laborCode where user='$user_name' and job_name='$job_select' order by job_name;"); 
    if($result)
    {
        echo "<select name=\"laborcode\" > <option default=\"default\" value=\"\">Choose One</option>"; 
        while($row=mysql_fetch_row($result))
        { 
            echo "<option value=\"$row[0]\">$row[0]</option>";
        } 
            echo "</select>";
    }
    else
    {
        echo mysql_error($result);
    }
}
 

This is a js that is (hopefully) reloading the page and seems to be storing the first value.

function reload(form)
{
    var val=form.job_select.options[form.job_select.options.selectedIndex].value;
    self.location='options_screen.inc.php?job_select=' + val ;
    return val;
}
 

This is the HTML code that calls the php functions

<td><?php dd_joblist($user_name) ?></td>
<td><?php dd_laborlist($user_name, $job_select) ?></td>
 

I am almost to the point of pulling my hair out. Any help would be greatly appreciated

[iam_clint]

<select onchange="window.location='select.php?language='+this.value">
<option value="0">- Select Language -</option>
<option value="1" <?if ($language == 1) {?>selected<?}?>>English</option>
<option value="2" <?if ($language == 2) {?>selected<?}?>>Chinese</option>
</select>
 

heres a way to pass the selected value to a page of your desire --- the value can be retrieved by

 <? $language = $_GET["language"]; ?>

i think this is what you are looking for good luck and let me know if you have any problems with this

[JimS]

onchange="window.location='select.php?language='+this.value"
 

I am assuming this reloads the page back into itself?