EVOLUTION-NINJA

Edit File: TestResultModel.php

<?php namespace App\Models; use CodeIgniter\Model; class TestResultModel extends Model { public function getResults() { return $this->db->table('answered_questions') ->select('login.username AS name, count(answered_questions.correct_answer) as total_marks') ->join('login', 'login.login_id = answered_questions.answered_by') ->join('questions','questions.qid = answered_questions.question_id') ->where('questions.ans=answered_questions.correct_answer') ->groupBy('answered_questions.answered_by') ->get() ->getResult(); } }