Jump to content

PHP need value for select statement


reptile

Recommended Posts

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 by Zane
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.