Can somebody tell me pls where the error is in my code below? I have been trying to join two tables to get exam scores but I always get the error that `Warning: PDOStatement:execute(): SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in C:direcory'
Here is my code:
function getEmptyExamScores($conn, $course_code, $level, $year, $semester) {
$stmt = $conn->prepare('SELECT * FROM exams INNER JOIN register_course ON exams.course_code = register_course.course_code WHERE exams.course_code = :exams.course_code AND level = :level AND year = :year AND semester = :semester;');
$stmt->execute(['exams.course_code' => $course_code, 'level' => $level, 'year' => $year, 'semester' => $semester]);
return $stmt->fetchAll();
}