} $st = select_all_student($cur_dep, $cur_sem); ?> <h2 class="page-header">Attendance status are as follows...</h2> <table class="table table-bordered"> <tr> <th> USN </th> <th> Name </th> <th> Classes Attended </th> </tr> <!--PHP--> <?php while ($stude = mysqli_fetch_assoc($st)) { $cur_usn = $stude["USN"]; $att = retrive_attend($cur_usn, $cur_sem, $cur_sub); $d = mysqli_fetch_assoc($att); ?> <tr> <td><?php echo $stude["USN"]; ?> </td> <td><?php echo $stude["name"]; ?> </td> <td><?php echo $d["count(t)"]; ?>
while ($subj = mysqli_fetch_assoc($sublist)) { ?> <tr> <td> <?php echo $subj["Suid"]; ?> </td> <td><?php echo $subj["Su_name"]; ?> </td> <td> <?php $i = retrive_happned($cur_dep, $cur_sem, $subj["Suid"]); $j = mysqli_fetch_assoc($i); echo $j["count(DISTINCT t)"]; ?> </td> <td><?php $i = retrive_attend($cur_usn, $cur_sem, $subj["Suid"]); $j = mysqli_fetch_assoc($i); echo $j["count(t)"]; ?> </td> </tr> <?php } ?> </tbody> </table> </div>