model

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class M_pengembalian extends CI_Model {

	function get_selected($no)
	{
		$query	= "
					SELECT tp_transaksi.transaksi_pinjam, tp_transaksi.anggota_nis, tm_anggota.anggota_nama, (SELECT COUNT(buku_kode) FROM tp_transaksi WHERE transaksi_no = $no) as banyak
					FROM tp_transaksi
					INNER JOIN tm_anggota ON tp_transaksi.anggota_nis = tm_anggota.anggota_nis
					WHERE tp_transaksi.transaksi_no = $no
				";

		$link 	= $this->db->query($query);

		return $link->row_array();
	}

}

/* End of file M_pengembalian.php */
/* Location: ./application/models/M_pengembalian.php */