$query = $this->db->query("SELECT A.*,B.kode_mk,B.nama_mk,B.sks FROM kontrak_kuliah_mahasiswa AS A LEFT JOIN mata_kuliah AS B ON A.id_mk=B.id_mk LEFT JOIN data_mahasiswa AS C ON A.id_mahasiswa=C.id_mahasiswa WHERE C.nim_mahasiswa='".$nim."' AND A.nilai != '' ORDER BY B.kode_mk");