vipok

//Chcę wyświetlić datę, przedmiot, imię i nazwiska uczniów

    <?php
    $sql = "SELECT
    l.date as 'date',
    u.first_name as first_name,
    u.last_name as last_name,
    s.subject_name as subject_name
    FROM sms_lessons l
    JOIN sms_courses c ON c.id=l.course_id
    JOIN sms_teachers t ON t.id=c.teacher_id
    JOIN sms_users u ON u.id=t.user_id
    JOIN sms_subjects s ON s.id=c.subject_id
    WHERE l.date=:attendancedate AND c.subject_id=:subjectid AND t.id=:teacherid";

    $result = $pdo->prepare($sql);
    $result->bindValue(':attendancedate', $attendance_date);
    $result->bindValue(':subjectid', $subject_id);
    $result->bindValue(':teacherid', $query_teacher_id);
    $result->execute();
    $row_count = $result->rowCount();
    ?>

// sms_lessons --> id | date | visited | course_id
// sms_courses --> id | student_id | subject_id | teacher_id
// sms_subjects --> id | subject_name
// sms_teachers --> id | user_id
// sms_users --> id | first_name | last_name [...]

// Zamiast zwracać mi imię i nazwisko ucznia zwraca mi imię i nazwisko nauczyciela