Results 1 to 2 of 2

Thread: while loop inside while loop

  1. #1
    Join Date
    Sep 2010
    Posts
    188

    while loop inside while loop

    Hi..
    I have while loop inside while loop but I encountered problem in displaying data inside while loop or the second while loop.

    here is my code:

    Code:
    <?php
      error_reporting(0);
    $con = mysql_connect('localhost', 'root','');
    
    if (!$con) {
        echo 'failed';
        die();
    }
    
    mysql_select_db("mes", $con);
    ?>
    <script type="text/javascript">
    function showDetails(pcode) {
     
     var clickElement = pcode.value;
     var click_id = pcode.id; 
                   
    // var value_ =  document.getElementById(click_id).checked
     //    =  document.getElementById(clickElement).checked;   
     //var Table = (document.getElementsByName('list')[0].value);     
     
     var Table = document.getElementById('kanban_list'); 
    
     var rows = Table.rows;   
     
     var strSelect = document.getElementById(click_id).value;
     //alert(strSelect)
     
     for (var i = 0; i < rows.length; i++) {      
          var row = rows[i];      
        //row.style.display = (row.id.substr(0,3) == strSelect) ?      'none'         :          '';   
        //row.style.display = (row.id.substr(0,3) == strSelect) ? 
       // row.style.display = 'none';
       // row.style.display = '';
        
        if (row.id.substr(0,3) == strSelect) {
            row.style.display = ((document.getElementById(click_id).checked) == false) ?  'none' : ''
        }
        //(document.getElementById(click_id).checked == false) ?  'none'               : '' : '';   
     
     }  
       
    }
    
    </script>
    <?php
    $sql = "SELECT kc.PCODE, kc.count_wip_chemical_weighing, kc.count_wip_compounding, kc.count_wip_extrusion, 
    kc.count_wip_forming, kc.count_wip_deflashing, kc.kanban, kc.virtual, p.max_lot, p.min_lot FROM kanban_checker kc 
    JOIN plan p ON kc.PCODE = p.PCODE ORDER BY p.PCODE";    
    $result = mysql_query($sql, $con);       
    ?><label>Display Details:</label><input  onclick='showDetails(this);' id='chkDetail'   type='checkbox' checked='checked' value='wip'/>
    <?php
    echo "<table id='kanban_list'>";
    echo "<tr>
            <th> PCODE </th>
            <th> LOT CODE </th>
            <th> CHEMICAL WEIGHING </th>
            <th> COMPOUNDING </th>
            <th> EXTRUSION </th>
            <th> FORMING </th>
            <th> DEFLASHING </th>
            <th> KANBAN </th>
            <th> VIRTUAL </th>
            <th> MAX LOT </th>
            <th> MIN LOT </th>
         </tr>";
    while($row = mysql_fetch_assoc($result)){ 
        echo "<tr>
            <td>$row[PCODE]</td>
            <td>&nbsp;</td>
           <!-- <td>$row[LOT_CODE]</td>   -->
            <td>$row[count_wip_chemical_weighing]</td>
            <td>$row[count_wip_compounding]</td>
            <td>$row[count_wip_extrusion]</td>
            <td>$row[count_wip_forming]</td>
            <td>$row[count_wip_deflashing]</td>
            <td>$row[kanban]</td>
            <td>$row[virtual]</td>
            <td>$row[max_lot]</td>
            <td>$row[min_lot]</td>
            </tr>";     
    $sql = "SELECT kd.LOT_CODE, kd.wip_chemicalweighing, kd.wip_compounding, kd.wip_extrusion, kd.wip_forming, kd.wip_deflashing 
    FROM kanban_data kd JOIN plan p ON kd.PCODE = p.PCODE ORDER BY p.PCODE "; 
    $result_kanban_data = mysql_query($sql, $con);   
    
    while($row_data = mysql_fetch_assoc($result_kanban_data)){    
        echo "<tr id='wip'>
        <td></td>
        <td>&nbsp;$row_data[LOT_CODE]</td>
        <td>&nbsp;$row_data[wip_chemicalweighing]</td>
        <td>&nbsp;$row_data[wip_compounding]</td>
        <td>&nbsp;$row_data[wip_extrusion]</td>
        <td>&nbsp;$row_data[wip_forming]</td>
        <td>&nbsp;$row_data[wip_deflashing]</td>
        </tr>"; 
    }       
    }
    echo "</table>";
         
    ?>
    I attach the image of result from this code

    But the output that I want is all LOT_CODE with P35 PCODE will only display below P35
    and all LOTCODE with P35M PCODE will only display below P35M.

    Thank you

    I hope somebody can help me..
    Attached Images Attached Images

  2. #2
    Join Date
    Mar 2012
    Posts
    93
    yes, you are defined the while loop inside the while loop.

Similar Threads

  1. for loop issue!
    By efc_90 in forum Client & Server Side Scripting (PHP, ASP, JavaScript)
    Replies: 1
    Last Post: 10 Jan 2011, 05:25 PM
  2. two records from the same table in for loop
    By catalepticstate in forum Client & Server Side Scripting (PHP, ASP, JavaScript)
    Replies: 0
    Last Post: 11 Oct 2010, 04:26 AM
  3. How do I loop a video using HTML?
    By brynjarh in forum Web Design, HTML Reference and CSS
    Replies: 1
    Last Post: 29 Jan 2008, 09:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •