Can't select from SQL-View in CodeIgniter

Question

When I try this

$this->db->query('SELECT * FROM WMY_VIEW WHERE id_bla = ? 
ORDER BY bla, blabla', array($bla))->result_array();

I'm getting this error

Query error: ERROR:  relation "WMY_VIEW" does not exist.

WMY_VIEW is a sql-view, not a table. BUT in regular php, it works

$sql = "SELECT * FROM WMY_VIEW WHERE id_bla=".$bla." ORDER BY bla, blabla";
$results = pg_query(CONEXION, $sql);

What's the problem with CI? What I'm missing?

PS: Database (PostgreSQL) it's not mine.

http://stackoverflow.com/questions/16355655/how-to-create-a-viewsql-in-codeigniter-and-select-data-from-it — Alive to die - Anant, Mar 02 '16 at 17:01

score 3 · Accepted Answer · answered Mar 03 '16 at 03:33

3

Try this

$this->db->where('id_bla',$id_bla);
$this->db->order_by('bla','desc');
$query = $this->db->get('WMY_VIEW');
return $query->result_array();

answered Mar 03 '16 at 03:33

Visarut Sae-Pueng

1 Answers1