Why while loop is displaying single row?

Question

I am trying to run while loop in a while loop, but only single row is displayed.

  <?php    
    if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT u.id, u.firstname, u.lastname, u.email, c.fullname, ro.shortname, c.id as courseid
from mdl_context cx 
Left join mdl_course c ON cx.instanceid = c.id
Left join mdl_role_assignments r  on  r.contextid = cx.id
Left join mdl_user u on u.id = r.userid
Left join mdl_role ro on ro.id = r.roleid
WHERE r.roleid IN (11)
AND cx.contextlevel =50 GROUP BY u.id ORDER BY u.id ASC";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    echo "<table>"."<tr>"."<td width='100px;'><h4>Name</h4></td>"."<td width='50px;'>"."</td>"."<td width='230px;'><h4>Email</h4></td>"."<td width='100px;'><h4>Role</h4></td>"."<td width='100px;'>"."</td>"."<td><h4>Course</h4></td>"."</table>"."<br>";
    while($tmg = $result->fetch_assoc()) {
    echo "<table>"."<tr>"."<td width='100px;'><a href='http://localhost/user/profile.php?id=".$tmg["id"]."'>".$tmg["firstname"]." ".$tmg["lastname"]."</a></td>"."<td width='50px;'>"."</td>"."<td width='230px;'>".$tmg["email"]."</td>"."<td width='100px;'>".$tmg["shortname"]."</td>";
    while($row = $result->fetch_assoc()) {
    echo    "<td width='100px;'>"."</td>"."<td>".$row["fullname"]."</td>"."</table>"."<br>";
    }
    }
} else {
    echo "0 results";
}
$conn->close();
 ?>

Any guidance or help will be much appreciated.

I've corrected the code. Now outer while loop is executing once! Why? — MOZ
– MOZ, Commented May 29, 2015 at 11:36

Narendrasingh Sisodia · Accepted Answer · 2015-05-29 11:34:01Z

1

A typo need to execute another query $sqlt as

$sqlt = "SELECT u.firstname, u.lastname, c.id, c.fullname FROM mdl_course AS c JOIN mdl_context AS ctx ON c.id = ctx.instanceid JOIN mdl_role_assignments AS ra ON ra.contextid = ctx.id JOIN mdl_user AS u ON u.id = ra.userid WHERE u.id IN ($newarray)";
$result2 = $conn->query($sqlt);//forgot to execute
while($row = $result2->fetch_assoc()) {

answered May 29, 2015 at 11:34

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

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

3 Comments

MOZ Over a year ago

I've corrected the code, now outer while loop is executing once! Why?

Narendrasingh Sisodia Over a year ago

Why you were fetching same array twice

MOZ Over a year ago

Because at 1st i want unique records and in second i want to display all the courses related to 1st array id.

Collectives™ on Stack Overflow

Why while loop is displaying single row?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related