CI 1.7: $db->get() and Join |
[eluser]Unknown[/eluser]
As like as this post: http://ellislab.com/forums/viewthread/95148/ My code is Code: $this->db->select('user_detail.*, industries.name industry_name'); But I get error because the translated sql is listed below: Quote:SELECT user_detail.*, industries.name industry_nameLook the line 2, there are two same table name split by comma. The comma is redundant.
[eluser]henrihnr[/eluser]
[quote author="Derek Hsu" date="1225466660"]As like as this post: http://ellislab.com/forums/viewthread/95148/ My code is Code: $this->db->from('user_detail'); [/quote] notice 2 lines of code above..you've defined table twice..
[eluser]Unknown[/eluser]
The same code was ok in 1.6.3. But it's not work in 1.7.0 |
Welcome Guest, Not a member yet? Register Sign In |