Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- NAME ROLL NO SUB1 SUB2 SUB3 TOTAL RESULT POSITION RANK
- RAM 0054 65 54 64 183 PASS FIRST 2
- HAri 0054 65 54 65 184 PASS FIRST 1
- gopal 0054 65 50 65 180 PASS FIRST 3
- saroj 0054 65 44 65 174 PASS FIRST 4
- BUT WITH THE FOLLOWING CODE
- <table width="400" border="1">
- <thead>
- <tr>
- <!-- -->
- </tr>
- </thead>
- <tbody>
- <?php
- $query = "SELECT * FROM Marksheet_student
- JOIN `class` ON `Marksheet_student`.`class_id` = `class`.`class_id`
- JOIN `student` ON `Marksheet_student`.`student_id`=`student`.`student_id`
- JOIN `section` ON `Marksheet_student`.`section_id`=`section`.`section_id`
- JOIN `subjects` ON `Marksheet_student`.`subject_id`=`subjects`.`subject_id` ";
- $select_result = mysqli_query($db_con, $query);
- if (!$select_result) {
- die("no result" . mysqli_error($db_con));
- }
- while ($row = mysqli_fetch_array($select_result)) {
- $student_name = $row['firstname'];
- $subject_name = $row['name'];
- $first_CA = $row['first_CA'];
- $second_CA = $row['second_CA'];
- $exams = $row['exams'];
- $class_name = $row['class_name'];
- $section_name = $row['section_name'];
- echo "<tr>";
- echo "<td> $student_name </td>";
- echo "<td> $subject_name </td>";
- echo "<td> $first_CA </tr>";
- echo "<td> $second_CA </tr>";
- echo "<td> $exams </tr>";
- echo "<td> $class_name </tr>";
- echo "<td> $section_name </tr>";
- echo "</tr>";
- }
- ?>
- </tbody>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement