Hello!
I am using PHP version 5.7
and Code Igniter 3
I have 2 tables.
1. krs
2. matakuliah
this is the code
$nim = $this->input->post('nim', TRUE);
$thn_ak = $this->input->post('$id_thn_ak', TRUE);
$query = "SELECT krs.id_thn_ak
,krs.kode_matakuliah
,matakuliah.nama_matakuliah
,matakuliah.sks
,krs.nilai
FROM
krs
INNER JOIN matakuliah
ON (krs.kode_matakuliah = matakuliah.kode_matakuliah)
WHERE krs.nim = $nim AND krs.id_thn_ak = $thn_ak";
and I got an error like this
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INNER JOIN matakuliah ON (krs.kode_matakuliah = matakuliah.kode_matak...' at line 9
SELECT krs.id_thn_ak ,krs.kode_matakuliah ,matakuliah.nama_matakuliah ,matakuliah.sks ,krs.nilai FROM krs WHERE krs.nim = 18024114 AND krs.id_thn_ak = INNER JOIN matakuliah ON (krs.kode_matakuliah = matakuliah.kode_matakuliah)
Filename: C:/xampp/htdocs/sisfo_akademik/system/database/DB_driver.php
Line Number: 692
Thank You.