Hi all
How to do UNION query with codeigniter's active record?
+4
A:
CodeIgniter's ActiveRecord doesn't support UNION, so you would just write your query and use the ActiveRecord's query method.
$this->db->query('SELECT column_name(s) FROM table_name1 UNION SELECT column_name(s) FROM table_name2');
Zack
2010-01-11 20:39:29
To explain, CodeIgniter's ActiveRecord only supports SQL features that are compatible with all its supported SQL types (or implements them in its own way).The idea of ActiveRecord is to abstract the database type to be database independant and let people move from MySQL to MSSQL or whatever else without major issue. If they tried to add unison it would screw with other database types.
Phil Sturgeon
2010-01-12 16:04:45
database independant and let people move from MySQL to MSSQL or whatever else without major issue
jim
2010-10-14 22:08:37