tangaye

<?php
  function first_semester_report($student_id) {
		  global $connection;
		  $query = "SELECT period_one.score, period_one.subject_id, period_two.score, period_two.subject_id, period_three.score, period_three.subject_id
			from students

			LEFT JOIN period_one
            ON students.student_id = period_one.student_id
            AND students.current_class_id = period_one.class_id