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

/**
 * Description of PartEigenpijlers_model
 *
 * @author Theo Weijmer
 * @date mei 8, 2013   4:21 PM
 *
 */

class part_eigenpijlers_model extends MY_Model{

	protected $tablename 	= 'tb_parteigenpijlers';

	function __construct(){
		parent::__construct();
		$models = array();
		$this->load->model($models);
	}
	function get_pijlers($partID){
		$this->sql="SELECT  pep.id,
							ep.eigenpijler_naam as naam
					 FROM tb_parteigenpijlers pep
					 JOIN     tb_eigenpijlers ep
					 ON       pep.eigenpijlerID = ep.id
					 WHERE pep.partituurID = $partID" ;
		return $this->get_query_result();			 
	}
}