Jump Menu Dynamic Drop Down Menu

[snh]

Hello,

I have a coded two drop down boxes which pull information from a MySQL database. I am currently using a javascript jump menu to refresh the page, which then generates the second drop down box (based on the selection in the first drop down box). My question is that when the page refreshes all my previous data is lost. Do you know of any way in which I can retain the values within the rest of my form? Any suggestions would be great! Thanks

Here is the jump menu code I am using:

    <script language="JavaScript" type="text/JavaScript">
    <!--
    function MM_jumpMenu(targ,selObj,restore){ //v3.0
      eval(targ+".location='"+"Pratt_Instance_1.php?mcate="+selObj.options[selObj.selectedIndex].value+"&mind="+selObj.selectedIndex+"'");
      if (restore) selObj.selectedIndex=0;
    }
    function MM_jumpMenu2(targ,selObj,restore){ //v3.0
    eval(targ+".location='"+"Pratt_Instance_1.php?mcate="+selObj.options[selObj.selectedIndex].value+"&mind="+selObj.selectedIndex+"$cate="+selObj.options[selObj.selectedIndex].value+"&ind="+selObj.selectedIndex);
      if (restore) selObj.selectedIndex=0;
    }
    //-->
    </script>

and the drop down box SQL code

   <select id="Instance_Type111" name="mcate" onchange="MM_jumpMenu('parent',this,0)">
                <option value="0">Select</option>
    <?php

                // Get the Categories from Database
                if (!isset($type_array)){
                 $type_array=get_category_name();

                $query = "SELECT Type_ID, Type_Name FROM Instance_Type111";
                   $query_result=@mysql_query($query,$mysql_link)
                         or die ('Could not get categories! <br>\n');
                   $type_array = db_result_to_array($query_result);
                   }
             // Display Categories in the menu listing
                $mi=1;
                foreach ($type_array as $row){
                $Type_ID= (string) $row['Type_ID'];
                $Type_Name= $row['Type_Name'];
                if ($mi!=$mind){
                print ("<option value=$Type_ID>$Type_Name</option>");
                } else {
                print ("<option value=$Type_ID selected>$Type_Name</option>");
                }
                     $mi++;
                }

                // Setting the main category code
          // $mcate_code is the maincat_id of main category chosen
             if(!isset($HTTP_GET_VARS['mcate']))   {
               $mcade_code = 0;
              } else{
               $mcade_code =  $HTTP_GET_VARS['mcate'];
             }
    ?></select></td>
                   </tr>
    <tr>
    <td>
    Detailed Incident Type:
    </td>
    <td >
    <select name="cate" id="Detailed_Instance_LUT111" onChange="MM_jumpMenu2('parent',this,0)">
    <option value="0"  >Select</option>
       <?php
    //Get Detailed Definition from Database
       $type_array=get_categories($mcade_code);
    // Display Categories in the menu listing
       display_category($type_array);

    // Setting the main category code
          // $cate_code is the maincat_id of main category chosen
             if(!isset($HTTP_GET_VARS['cate']))   {
               $icade_code = 0;
              } else{
               $icade_code =  $HTTP_GET_VARS['cate'];
             }
    ?></select></td>

Thanks

[Ancora]

See attached .zip file.

AJAX Dynamic Select List with PHP and MySQL.

Selected option in the first list, determines the options that populate a second list, which are retrieved from a MySQL database.