<?php

$sql = $conn->query("SELECT * from tb_coordinator inner join tb_teacher
on tb_coordinator.cd_coord = tb_teacher.cd_coord
inner join teacher_class on
tb_teacher.cd_teacher = teacher_class.cd_teacher
inner join tb_teacher on
teacher_class.cd_class = tb_class.cd_class
inner join tb_student on
tb_class.cd_class = tb_student.cd_class
where tb_teacher.cd_cpf = '$cpf' and nm_class = '3a1'  order by cd_number asc");

while($row = mysqli_fetch_array($sql)){
    $nm_student = $row['nm_student'];
    $cd_number = $row['cd_number'];
?>


<ul class="list-group list-group-flush" style="width: 50%; margin-top: 2%;">
    <div id="load_student">
      <li class="list-group-item"><?php echo $cd_number . " - " . $nm_student;?>
       <a href="students.php" ><button type="button" class="btn btn-outline-info" style="margin-left: 90%;">Get Information</button></a></li>
    </div>
</ul>

</div>
<?php }?>