Query multiple table with same field name using active record |
[eluser]aryan_[/eluser]
How do I query multiple tables with same field name using active record i.e. using Code: $this->db->select('id', 'name'); I don't like writing long sql statement.
[eluser]Asinox[/eluser]
Code: $this->db->join('table1','table1.id=table2.id')
[eluser]aryan_[/eluser]
Great! How do I access data of same name field? I think in sql query "AS" is used to set the name of columns. How to do using Active record? Thanks a lot!
[eluser]TheFuzzy0ne[/eluser]
You'll need to use aliases for any fields that match the names of fields in other tables used within your query.
[eluser]rogierb[/eluser]
Just use: Code: $this->db->select('some.id as some_id_number');
[eluser]Jevedor[/eluser]
here is a previous thread that i answered this in http://ellislab.com/forums/viewthread/109045/
|
Welcome Guest, Not a member yet? Register Sign In |