PHP need value for select statement

[reptile]

Hello everyone,

    I am having a pretty basic problem.  Below is a piece of my code, the first few lines of "Get Value for Bodyfitting" basically gets a value and assigns it to some variables through a select statement (this later on you will see that the values are being shown through echo on the screen in a form of a javascript dropdown for "Style Selection"), now the second few lines is where I have some issues in the "Value for Field 1", I want to get back a value by getting the answer from the first sql but I can't get the value for "$newBodyfitting" because it is only assigned later on, this will allow me to get a dropdown for a "Select Front", this is dependent on the "Select Style" if you see below, I know it might sound confusing.  Thanks in advance.

    //Get Division
    $div_query = "SELECT distinct DIVISION, CLOTHDB FROM MTM_DIVISIONS_S ORDER BY CLOTHDB";    
    $div_result = oci_parse($connect,$div_query);
    oci_execute($div_result);
    while ($div_row = oci_fetch_array($div_result, OCI_ASSOC)) {
      $divArray[] = "{$div_row['CLOTHDB']}";
      $divDivArray[] = "{$div_row['DIVISION']}";
    }
    oci_free_statement($div_result);
    //Get Value for Bodyfitting
    $bodyfitting_query="SELECT BODYFITTING, BFCODE FROM MTM_STYLES_S WHERE DIVISION= '".$divDivArray[$i]."' AND STYLE_TYPE='BODY' GROUP BY BODYFITTING, BFCODE ORDER BY BODYFITTING";   
    $bodyfitting_result = oci_parse($connect,$bodyfitting_query);
    oci_execute($bodyfitting_result);
   
    
    //Get Value for Field1
    $field1_query="SELECT MTM_STYLES_S.CODE,MTM_SUFFEX_S.TEXT FROM MTM_STYLES_S,MTM_SUFFEX_S WHERE MTM_SUFFEX_S.DIVISION='".$divDivArray[$i]."' AND      (MTM_STYLES_S.FIELD=MTM_SUFFEX_S.FIELD AND MTM_STYLES_S.CODE=MTM_SUFFEX_S.CODE) AND MTM_STYLES_S.STYLE_TYPE='BODY' AND MTM_STYLES_S.BODYFITTING='".$newBodyfitting."' AND MTM_STYLES_S.FIELD=1 ORDER BY MTM_STYLES_S.FIELD,MTM_STYLES_S.CODE";
    $field1_result = oci_parse($connect,$field1_query);
    oci_execute($field1_result);

    //Setup new dropdown for Style Selection
    echo "\tClearOptionsFastAlt('bodyfitting');\n";
    echo "\t\tdocument.pickDivision.textInput.value='';\n";
    echo "var divcomp = division.replace(/^\s+|\s+$/g, '');";
    echo "var selectObj = document.pickDivision.bodyfitting;\n";
    echo "var numShown = selectObj.options.length;\n";
    echo "selectObj.selectedIndex = -1;\n";
    echo "\t\t\tselectObj.options[numShown] = new Option('- Select Style -', '');\n";
    echo "\t\t\tnumShown++;\n";
    while ($bodyfitting_row = oci_fetch_array($bodyfitting_result, OCI_ASSOC)) {
        $newBodyfitting=$bodyfitting_row['BODYFITTING'];
        $newBfcode=$bodyfitting_row['BFCODE'];
        echo "\t\t\tselectObj.options[numShown] = new Option('".$newBfcode.' '.$newBodyfitting."', '".$newBfcode."');\n";
      echo "\t\t\tnumShown++;\n";      
      $y++;
     }
     
    //Setup dropdown new Front dependent on Style above
    echo "\t\t\tdocument.pickDivision.bodyfitting.options[0].selected = true;\n\n";
    echo "\t\tdocument.pickDivision.field1;\n";
    echo "\tClearOptionsFastAlt('field1');\n";
    echo "\t\tdocument.pickDivision.textInput.value='';\n";
    echo "var divcomp = division.replace(/^\s+|\s+$/g, '');";
    echo "var selectObj = document.pickDivision.field1;\n";
    echo "var numShown = selectObj.options.length;\n";
    echo "selectObj.selectedIndex = -1;\n";
    echo "\t\t\tselectObj.options[numShown] = new Option('- Select Front -', '');\n";
    echo "\t\t\tnumShown++;\n";
    
    while ($field1_row = oci_fetch_array($field1_result, OCI_ASSOC)) {
        $newField1=$field1_row['TEXT'];
        $newField2=$field2_row['CODE'];
        echo "\t\t\tselectObj.options[numShown] = new Option('".$newField1.''.$newField2."');\n";
      echo "\t\t\tnumShown++;\n";      
      $y++;
    }
   
       echo "\t\t\tdocument.pickDivision.field1.options[0].selected=true;\n\n";
       
       oci_free_statement($field1_result);
       oci_free_statement($bodyfitting_result);

Edited October 30, 2013 by Zane