PHP Loop with in a loop

Question

I have a database containing a list of students with their names and availed books (list of books, serialized, stored in one row). I and now trying to display all of the students and the list of books they availed, I created a loop within a loop, but the thing is it just display the first record. It displays fine, but just the first record.

mysql_select_db("MYDB", $con);
$result = mysql_query("Select * From EnrolleeList where Gradelvl = 2 Order By Lname ASC");
while($row=mysql_fetch_array($result))
    {
    echo $row['name'] . " " . $row['lastname'];
    $glvl = $row['Gradelvl'];
    $getbooks = $row['BookList']; //data containing book list

    $getbooks = unserialize($getbooks);
    $arrlength = count($getbooks);  

    for($actr = 0; $actr < $arrlength; $actr++) 
        {
        $result = mysql_query("Select * From  ELEMBooks where GradeLevel = '$glvl' and BID = '$getbooks[$actr]' ");
        while($row = mysql_fetch_array($result))
            {
            echo $row['Subject'];
            echo " - ";
            echo $row['Book'];
            echo " - ";
            echo $row['Weight'];
            echo " - ";
            }
        }       
}
mysql_close($con);

Just use different variable name for inner loop $row, $result etc. else your upper var values will be overwrite and your upper loop will be failed to get correct — Rakesh Sharma
– Rakesh Sharma, Commented Jun 16, 2016 at 6:06

Dhara Parmar · Accepted Answer · 2016-06-16 06:09:32Z

2

For outer loop use $row and for inner row use different variable ex. $rowInner and same for all duplicate variables

while($row=mysql_fetch_array($result)) // $row here
    {
    echo $row['name'] . " " . $row['lastname'];
    $glvl = $row['Gradelvl'];
    $getbooks = $row['BookList']; //data containing book list

    $getbooks = unserialize($getbooks);
    $arrlength = count($getbooks);  

    for($actr = 0; $actr < $arrlength; $actr++) 
        {
        $resultInner = mysql_query("Select * From  ELEMBooks where GradeLevel = '$glvl' and BID = '$getbooks[$actr]' ");
        while($rowInner = mysql_fetch_array($resultInner)) // $rowInner here
            {
            echo $rowInner['Subject'];
            echo " - ";
            echo $rowInner['Book'];
            echo " - ";
            echo $rowInner['Weight'];
            echo " - ";
            }
        }       
}

edited Jun 16, 2016 at 6:09

answered Jun 16, 2016 at 6:06

Dhara Parmar

8,1231 gold badge19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rakesh Sharma Over a year ago

Would be better if you Explain why use diifer var name?

Collectives™ on Stack Overflow

PHP Loop with in a loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related