[eluser]Unknown[/eluser]
When performing SQL queries fetching data from multiple tables, fields that have the same name in two different tables (overlap) will only return one (unless effort is taken to specify alternate field names using AS).
I want to switch to CI from my own small-footprint MVC, but one of the things I would miss most is how my framework would return table data in a nested array similar to:
$result[0]["table1"]["field1"] ...
$result[0]["table2"]["field2"] ...
Cake does this as well, which makes it extremely simple to perform joins and access data specific to each table.
Is there anyway to do this in CI?? Not only is it much simpler, but it also helps remove unexpected bugs because of the field overlap.