[eluser]Unknown[/eluser]
hai all. I have problem with My query :
* this My function in Model :
function data_cari2($field, $kunci)
{
$query = $this->db->query
("SELECT nama_kelas,simdik_core_matapelajaran.matapelajaran
FROM simdik_kelas
JOIN simdik_core_matapelajaran on simdik_kelas.nama_kelas like $field
and simdik_core_matapelajaran.matapelajaran
like$kunci");
return $query;
}
* this error message:
A Database Error Occurred
Error Number:
ERROR: syntax error at or near "Indonesia" LINE 4: ...d simdik_core_matapelajaran.matapelajaran like Bhs Indonesia ^
SELECT nama_kelas, simdik_core_matapelajaran.matapelajaran FROM simdik_kelas JOIN simdik_core_matapelajaran on simdik_kelas.nama_kelas like user_nama and simdik_core_matapelajaran.matapelajaran like Bhs Indonesia
Filename: C:\xampp\htdocs\simdik\system\database\DB_driver.php
Line Number: 330
*******************
note :
I am newbie in CI.
thanks for all and GOD bless You