[eluser]aprij4nto13[/eluser]
the model view in absen_model.zip on attachment
a part of this (get_last_ten_absen) function is like this
[/code]
function get_last_ten_absen($limit, $offset)
{
$this->db->select('absen.id_absen, absen.tanggal, absen.nis, siswa.nama, kelas.kelas, absen.absen');
$this->db->from('absen, siswa, kelas, semester');
$this->db->where('siswa.id_kelas = kelas.id_kelas');
$this->db->where('absen.nis = siswa.nis');
$this->db->where('semester.id_semester = absen.id_semester');
$this->db->order_by('absen.tanggal', 'desc');
$this->db->limit($limit, $offset);
return $this->db->get();
}
Code:
that any mistake with this query
I try to simplify the query code like this code
function get_last_ten_absen($limit, $offset)
{
$this->db->select('absen.id_absen, absen.tanggal, absen.nis, absen.nama, absen.id_kelas, absen.absen');
$this->db->from('absen');
$this->db->order_by('absen.tanggal', 'asc');
$this->db->limit($limit, $offset);
return $this->db->get();
}
[code]
when i used debug with your suggest the array data is show, but in the grid the data still not show and the error still same..
thanks