change the way mysql returns columns to php zf 2 sql -
im getting using zend\db\sql.
the 2 tables share similar columns names, {id,name,...}
when access result set, column names overwritten because of this.
is there way mysql or zf2 return like:
'table1.id', 'table1.name', 'table2.id', table2.name'
so can filter there without having in query:
select 'table1.id table1_id', 'table1.name tablel1_name', 'table2.id table2_id', table2.name table2_name'
thanks!
Comments
Post a Comment